Analyze and reduce big tables in DB

[mlissner]

Over in #1404 I noticed that the DB is taking up more space than it should be. Why? Well....it could be the django_cache table, but there are a few other huge ones too. Here's an analysis (from the disk usage postgres wiki page):

SELECT *, pg_size_pretty(total_bytes) AS total
    , pg_size_pretty(index_bytes) AS index
    , pg_size_pretty(toast_bytes) AS toast
    , pg_size_pretty(table_bytes) AS table
  FROM (
  SELECT *, total_bytes-index_bytes-coalesce(toast_bytes,0) AS table_bytes FROM (
      SELECT c.oid,nspname AS table_schema, relname AS table_name
              , c.reltuples AS row_estimate
              , pg_total_relation_size(c.oid) AS total_bytes
              , pg_indexes_size(c.oid) AS index_bytes
              , pg_total_relation_size(reltoastrelid) AS toast_bytes
          FROM pg_class c
          LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
          WHERE relkind = 'r'
  ) a
) a order by total_bytes desc;

oid	table_schema	table_name	row_estimate	total_bytes	index_bytes	toast_bytes	table_bytes	total	index	toast	table
16916	public	search_recapdocument	1.45108e+08	245215191040	107473125376	114006269952	23735795712	228 GB	100 GB	106 GB	22 GB
16872	public	search_opinion	4.38602e+06	162948743168	8195358720	151757185024	2996199424	152 GB	7816 MB	141 GB	2857 MB
16480	public	django_cache	167035	115602481152	85442560	115494256640	22781952	108 GB	81 MB	108 GB	22 MB
16859	public	search_docketentry	1.4223e+08	89793044480	55615815680	170508288	34006720512	84 GB	52 GB	163 MB	32 GB
16841	public	search_docket	1.78687e07	57446711296	51288203264	622592	6157885440	54 GB	48 GB	608 kB	5873 MB
14576403	public	lasc_action	5.51562e07	25476235264	12134678528	8192	13341548544	24 GB	11 GB	8192 bytes	12 GB
14576436	public	lasc_documentfiled	4.52151e+07	17989279744	10014859264	8192	7974412288	17 GB	9551 MB	8192 bytes	7605 MB
16903	public	search_opinionscited	3.9641e+07	14191468544	11440087040		2751381504	13 GB	11 GB		2624 MB
16767	public	recap_fjcintegrateddatabase	9.44851e+06	13534175232	10077487104	8192	3456679936	13 GB	9611 MB	8192 bytes	3297 MB
16789	public	recap_rss_rssfeedstatus	3.67022e+06	10134224896	9878896640		255328256	9665 MB	9421 MB		244 MB
16645	public	people_db_attorney	6.64636e+06	9330458624	7481671680	8192	1848778752	8898 MB	7135 MB	8192 bytes	1763 MB
14576509	public	lasc_queuedpdf	1.18976e+07	8186683392	6650052608		1536630784	7807 MB	6342 MB		1465 MB
16746	public	people_db_role	1.87248e+07	7449198592	5901557760	8192	1547632640	7104 MB	5628 MB	8192 bytes	1476 MB
16924	public	search_recapdocument_tags	3.61674e+07	6259810304	3650265088		2609545216	5970 MB	3481 MB		2489 MB
16867	public	search_docketentry_tags	3.40792e+07	6019555328	3435954176		2583601152	5741 MB	3277 MB		2464 MB
14576447	public	lasc_documentimage	1.22302e+07	5941673984	2554445824	8192	3387219968	5666 MB	2436 MB	8192 bytes	3230 MB
14576490	public	lasc_proceeding	1.0176e+07	4430831616	2142896128	8192	2287927296	4226 MB	2044 MB	8192 bytes	2182 MB
14576479	public	lasc_party	1.15634e+07	4284743680	2404884480	8192	1879851008	4086 MB	2293 MB	8192 bytes	1793 MB
16701	public	people_db_partytype	8.62674e+06	3990421504	3059933184	57344	930430976	3806 MB	2918 MB	56 kB	887 MB
16781	public	recap_processingqueue	3.95982e+06	3481624576	2862972928	8192	618643456	3320 MB	2730 MB	8192 bytes	590 MB
16693	public	people_db_party	9.56125e+06	3375308800	2575654912	81920	799571968	3219 MB	2456 MB	80 kB	763 MB
16885	public	search_opinioncluster	4.32201e+06	3287695360	1770086400	201539584	1316069376	3135 MB	1688 MB	192 MB	1255 MB
16826	public	search_citation	4.05945e+06	1423851520	1202085888	8192	221757440	1358 MB	1146 MB	8192 bytes	211 MB
14576425	public	lasc_docket	1.83436e+06	1362386944	704528384	8192	657850368	1299 MB	672 MB	8192 bytes	627 MB
16661	public	people_db_attorneyorganizationassociation	5.03461e+06	1181843456	929185792		252657664	1127 MB	886 MB		241 MB

Things I see:

• Django cache is very big. We use the cache_page decorator in a few places to put stuff in it. I think we should move this junk to disk, probably.
• The search_recapdocuments table has a huge index. It has a few columns with indexes, but none that look really bad. It's worth figuring out which column is causing this — maybe the date_modified/created fields, since there are 145M rows?

[mlissner]

I took a look in the cache table. There are two things in there:

1. Caches from the cache_page decorator
2. Caches from the citing work that @malteos is doing.

Because we cache sitemaps in the DB, I truly expected the sitemaps to the issue, but it turns out that items with the citing key are taking up much more space:

SELECT sum(pg_column_size(t.*)) as filesize, count(*) as filerow FROM django_cache as t where cache_key like ':1:citing:%';
  filesize   | filerow 
-------------+---------
 32243875824 |  167422

Translating that, it appears that we have 167k items with this cache key, taking up 32GB of space. I looked at the other rows in the table too, and none took up much space, so I actually think these are somehow taking up more like 100GB since that's what the whole table takes up.

Dividing 32GB by 167k rows, we learn that each row takes up about 192kb of space. Huge for a list of ten items. Something is off here.

What's worse is that I don't understand why we are even caching these, really. Here's the code:

def get_citing_clusters_with_cache(cluster, is_bot):
    """Use Solr to get clusters citing the one we're looking at

    If it's not a bot, cache the results for a long time. If it is a bot, load
    those results if they exist. Otherwise, return None.

    :param cluster: The cluster we're targeting
    :type cluster: OpinionCluster
    :param is_bot: Whether the page running this was loaded by a bot
    :type is_bot: bool
    :return: A search result of the top five citing clusters or None
    :rtype: SolrSearch or None
    """
    cache_key = "citing:%s" % cluster.pk
    cache = caches["db_cache"]
    if is_bot:
        # If the cache was set by a real user, bots can access it. But if no
        # user set the cache, this will just return None.
        return cache.get(cache_key)

    # Get the citing results from Solr for speed. Only do this for humans
    # to save on disk usage.
    sub_opinion_pks = cluster.sub_opinions.values_list("pk", flat=True)
    ids_str = " OR ".join([str(pk) for pk in sub_opinion_pks])
    q = {
        "q": "cites:(%s)" % ids_str,
        "rows": 5,
        "start": 0,
        "sort": "citeCount desc",
        "caller": "view_opinion",
    }
    conn = sunburnt.SolrInterface(settings.SOLR_OPINION_URL, mode="r")
    citing_clusters = conn.raw_query(**q).execute()
    a_month = 60 * 60 * 24 * 30
    cache.set(cache_key, citing_clusters, a_month)

    return citing_clusters

So...we are caching 100GB-worth of stuff and then serving it to bots? Meanwhile we aren't serving anything to users. This is a weird plan, but I know we went over this PR carefully. @malteos do you recall the thinking here? Seems like we should store something smaller in the cache and then serve it to users? I don't know why we wouldn't actually serve it?

[mlissner]

I'm putting a pause on this so I can go seek money for the org instead of doing DBA stuff, but this post is really good:

http://www.databasesoup.com/2014/05/new-finding-unused-indexes-query.html

It has a query that shows a bunch of indexes we have, ordered by size, that just aren't used at all. The first one is for the filepath_local field, which has two indexes. One is for looking it by value, and the other is for doing like queries, and has never been used. It's 10GB that's just free to reclaim. It looks like you can dial in the Django indexes using some of the tips here:

https://stackoverflow.com/a/50926644/64911

[mlissner]

This is the query that's so useful (I made a fork in case the original somehow gets deleted): https://gist.github.com/mlissner/976e413b01aa0877f2183edd9b01732d

[mlissner]

After the code push in #1408, we ran some SQL to clear out the old caches and then clean up the table:

This took a long time to run:

delete from django_cache where cache_key like ':1:citing:%';

After running the above, the table was still 108GB, so I read up on vacuuming and autovacuum. Autovacuuming will only mark pages as free to be re-used, but won't actually delete them, under the assumption that your tables are slowly growing and continuous autovacuuming will keep tables under control. In this case, since we let the table get so big, and since we don't expect it to get so big again, we needed to actually do a vacuum full. This actually copies the table and locks it too, but I did it because the table was so small after the above DELETE command:

courtlistener=> VACUUM FULL VERBOSE django_cache;
INFO:  vacuuming "public.django_cache"
INFO:  "django_cache": found 243 removable, 4554 nonremovable row versions in 2777 pages
DETAIL:  0 dead row versions cannot be removed yet.
CPU: user: 2.42 s, system: 2.40 s, elapsed: 14.21 s.

After that, the table usage went from 108GB to ½GB. Great.

[mlissner]

Well, we're very low on disk space and so I'm back on this task. I checked the tables and there's not much we can do there. Here's the latest info. The biggest mover is that django_cache is not that big since last time, and search_docket exploded due to crawling every PACER case:

oid	table_schema	table_name	row_estimate	total_bytes	index_bytes	toast_bytes	table_bytes	total	index	toast	table
16916	public	search_recapdocument	1.64802e+08	271877611520	130327060480	114130771968	27419779072	253 GB	121 GB	106 GB	26 GB
16872	public	search_opinion	5.34478e+06	165419597824	8993865728	151757185024	4668547072	154 GB	8577 MB	141 GB	4452 MB
16841	public	search_docket	5.83943e+07	149165309952	130864652288	761856	18299895808	139 GB	122 GB	744 kB	17 GB
16859	public	search_docketentry	1.65168e+08	105276465152	66429509632	181968896	38664986624	98 GB	62 GB	174 MB	36 GB
14576403	public	lasc_action	5.51561e+07	25476276224	12134719488	8192	13341548544	24 GB	11 GB	8192 bytes	12 GB
14576436	public	lasc_documentfiled	4.52149e+07	17989304320	10014883840	8192	7974412288	17 GB	9551 MB	8192 bytes	7605 MB
16903	public	search_opinionscited	4.53271e+07	14222049280	11471093760		2750955520	13 GB	11 GB		2624 MB
16767	public	recap_fjcintegrateddatabase	1.06013e+07	13534806016	10078117888	8192	3456679936	13 GB	9611 MB	8192 bytes	3297 MB
16645	public	people_db_attorney	7.03051e+06	10083966976	8194621440	8192	1889337344	9617 MB	7815 MB	8192 bytes	1802 MB
16789	public	recap_rss_rssfeedstatus	1.95077e+06	10030080000	9878896640		151183360	9565 MB	9421 MB		144 MB
16746	public	people_db_role	2.02607e+07	8315568128	6605578240	8192	1709981696	7930 MB	6300 MB	8192 bytes	1631 MB
14576509	public	lasc_queuedpdf	1.18974e+07	8188182528	6651551744		1536630784	7809 MB	6343 MB		1465 MB
14279526	public	search_bankruptcyinformation	3.23764e+07	6268641280	3846225920	8192	2422407168	5978 MB	3668 MB	8192 bytes	2310 MB
16924	public	search_recapdocument_tags	3.6238e+07	6259810304	3650265088		2609545216	5970 MB	3481 MB		2489 MB
16867	public	search_docketentry_tags	3.42523e+07	6019555328	3435954176		2583601152	5741 MB	3277 MB		2464 MB
14576447	public	lasc_documentimage	1.22301e+07	5941673984	2554445824	8192	3387219968	5666 MB	2436 MB	8192 bytes	3230 MB
16480	public	django_cache	222105	5665046528	82354176	5397209088	185483264	5403 MB	79 MB	5147 MB	177 MB
16885	public	search_opinioncluster	4.43477e+06	4613988352	2979766272	201277440	1432944640	4400 MB	2842 MB	192 MB	1367 MB
16781	public	recap_processingqueue	4.93585e+06	4498292736	3762216960	8192	736067584	4290 MB	3588 MB	8192 bytes	702 MB
14576490	public	lasc_proceeding	1.01759e+07	4431126528	2143191040	8192	2287927296	4226 MB	2044 MB	8192 bytes	2182 MB
14576479	public	lasc_party	1.15633e+07	4285071360	2405212160	8192	1879851008	4087 MB	2294 MB	8192 bytes	1793 MB
16701	public	people_db_partytype	9.40846e+06	4257406976	3326918656	57344	930430976	4060 MB	3173 MB	56 kB	887 MB
16693	public	people_db_party	1.04538e+07	3589627904	2735947776	81920	853598208	3423 MB	2609 MB	80 kB	814 MB
16826	public	search_citation	4.14136e+06	1463377920	1234952192	8192	228417536	1396 MB	1178 MB	8192 bytes	218 MB
14576425	public	lasc_docket	1.83432e+06	1362386944	704528384	8192	657850368	1299 MB	672 MB	8192 bytes	627 MB
16661	public	people_db_attorneyorganizationassociation	5.57733e+06	1258463232	986644480		271818752	1200 MB	941 MB		259 MB
16775	public	recap_pacerhtmlfiles	4.21184e+06	1029447680	485187584		544260096	982 MB	463 MB		519 MB
69728885	public	disclosures_investment	1.44503e+06	1014546432	441548800	8192	572989440	968 MB	421 MB	8192 bytes	546 MB
16653	public	people_db_attorneyorganization	679059	785776640	656867328	8192	128901120	749 MB	626 MB	8192 bytes	123 MB
15259025	public	recap_pacerfetchqueue	632384	700751872	604323840	8192	96419840	668 MB	576 MB	8192 bytes	92 MB
16799	public	scrapers_errorlog	11497	607354880	596525056	8192	10821632	579 MB	569 MB	8192 bytes	10 MB
14576458	public	lasc_lascjson	1.83747e+06	573341696	224575488		348766208	547 MB	214 MB		333 MB
61622162	public	recap_rss_rssfeeddata	2.16996e+06	559489024	277643264		281845760	534 MB	265 MB		269 MB
16794	public	recap_rss_rssitemcache	225241	371163136	337797120		33366016	354 MB	322 MB		32 MB
16854	public	search_docket_tags	2.05344e+06	322936832	231178240		91758592	308 MB	220 MB		88 MB
14279558	public	search_claimhistory	196619	196386816	150200320	8192	46178304	187 MB	143 MB	8192 bytes	44 MB
14576414	public	lasc_crossreference	619175	194994176	124297216	8192	70688768	186 MB	119 MB	8192 bytes	67 MB
14576467	public	lasc_lascpdf	316017	171556864	108789760	8192	62758912	164 MB	104 MB	8192 bytes	60 MB
16404	public	audio_audio	73142	135012352	100392960	8192	34611200	129 MB	96 MB	8192 bytes	33 MB
16898	public	search_opinioncluster_panel	803887	131956736	96288768		35667968	126 MB	92 MB		34 MB
16674	public	people_db_criminalcount	399173	130973696	44089344	155648	86728704	125 MB	42 MB	152 kB	83 MB
14279539	public	search_claim	161869	103628800	60997632	8192	42622976	99 MB	58 MB	8192 bytes	41 MB
16812	public	scrapers_pacerfreedocumentrow	116939	95289344	15572992	663552	79052800	91 MB	15 MB	648 kB	75 MB
16807	public	scrapers_pacerfreedocumentlog	364737	92938240	67354624		25583616	89 MB	64 MB		24 MB
16820	public	scrapers_urlhash	77134	57786368	40108032	8192	17670144	55 MB	38 MB	8192 bytes	17 MB
69728861	public	disclosures_financialdisclosure	26378	51650560	29310976	1458176	20881408	49 MB	28 MB	1424 kB	20 MB
16727	public	people_db_position	36788	26214400	21643264		4571136	25 MB	21 MB		4464 kB
16666	public	people_db_criminalcomplaint	109480	24616960	10240000	8192	14368768	23 MB	10000 kB	8192 bytes	14 MB
69728918	public	disclosures_reimbursement	28889	22765568	9043968	8192	13713408	22 MB	8832 kB	8192 bytes	13 MB
16939	public	stats_stat	20391	19226624	6332416		12894208	18 MB	6184 kB		12 MB
69728907	public	disclosures_position	28415	18579456	8863744	8192	9707520	18 MB	8656 kB	8192 bytes	9480 kB
16709	public	people_db_person	12254	12451840	8577024	8192	3866624	12 MB	8376 kB	8192 bytes	3776 kB
16412	public	audio_audio_panel	75574	11223040	7782400		3440640	11 MB	7600 kB		3360 kB
69728850	public	disclosures_debt	14616	9871360	4874240	8192	4988928	9640 kB	4760 kB	8192 bytes	4872 kB
16394	public	alerts_docketalert	27523	9650176	6242304		3407872	9424 kB	6096 kB		3328 kB
16984	public	visualizations_scotusmap_clusters	49751	9412608	6881280		2531328	9192 kB	6720 kB		2472 kB
16432	public	auth_user	26423	8773632	3203072	8192	5562368	8568 kB	3128 kB	8192 bytes	5432 kB
69728896	public	disclosures_noninvestmentincome	11309	8437760	3923968	8192	4505600	8240 kB	3832 kB	8192 bytes	4400 kB
16447	public	authtoken_token	25574	8101888	5578752		2523136	7912 kB	5448 kB		2464 kB
16962	public	visualizations_jsonversion	2043	7847936	335872	5554176	1957888	7664 kB	328 kB	5424 kB	1912 kB
14576501	public	lasc_queuedcase	3237	7651328	5234688		2416640	7472 kB	5112 kB		2360 kB
2619	pg_catalog	pg_statistic	1630	7233536	155648	3555328	3522560	7064 kB	152 kB	3472 kB	3440 kB
14279550	public	search_claim_tags	43818	6815744	4382720		2433024	6656 kB	4280 kB		2376 kB
16558	public	favorites_favorite	10919	6750208	5029888	8192	1712128	6592 kB	4912 kB	8192 bytes	1672 kB
16386	public	alerts_alert	2356	5906432	4612096	57344	1236992	5768 kB	4504 kB	56 kB	1208 kB
16908	public	search_originatingcourtinformation	15401	5693440	3784704	8192	1900544	5560 kB	3696 kB	8192 bytes	1856 kB
69728839	public	disclosures_agreement	7609	5496832	2351104	8192	3137536	5368 kB	2296 kB	8192 bytes	3064 kB
16949	public	users_userprofile	26154	4890624	1613824	8192	3268608	4776 kB	1576 kB	8192 bytes	3192 kB
16471	public	django_admin_log	19523	3833856	1679360	57344	2097152	3744 kB	1640 kB	56 kB	2048 kB
69728929	public	disclosures_spouseincome	15858	3293184	1507328	8192	1777664	3216 kB	1472 kB	8192 bytes	1736 kB
16978	public	visualizations_scotusmap	2297	2965504	1327104	376832	1261568	2896 kB	1296 kB	368 kB	1232 kB
16621	public	judges_school	6218	2834432	2236416		598016	2768 kB	2184 kB		584 kB
16545	public	donate_donation	5230	2449408	679936	8192	1761280	2392 kB	664 kB	8192 bytes	1720 kB
16754	public	people_db_school	5838	2252800	1712128		540672	2200 kB	1672 kB		528 kB
2608	pg_catalog	pg_depend	10359	1802240	1105920		696320	1760 kB	1080 kB		680 kB
1249	pg_catalog	pg_attribute	7349	1638400	499712		1138688	1600 kB	488 kB		1112 kB
16682	public	people_db_education	7091	1458176	925696		532480	1424 kB	904 kB		520 kB
16759	public	people_db_source	6105	1458176	630784	8192	819200	1424 kB	616 kB	8192 bytes	800 kB
14576517	public	lasc_tentativeruling	208	1425408	65536	1212416	147456	1392 kB	64 kB	1184 kB	144 kB
69728874	public	disclosures_gift	1696	1245184	581632	8192	655360	1216 kB	568 kB	8192 bytes	640 kB
1255	pg_catalog	pg_proc	2894	999424	352256	8192	638976	976 kB	344 kB	8192 bytes	624 kB
16722	public	people_db_politicalaffiliation	4738	974848	524288		450560	952 kB	512 kB		440 kB
16970	public	visualizations_referer	1212	884736	622592	8192	253952	864 kB	608 kB	8192 bytes	248 kB
1259	pg_catalog	pg_class	1482	671744	327680		344064	656 kB	320 kB		336 kB
16717	public	people_db_person_race	3759	655360	450560		204800	640 kB	440 kB		200 kB
2618	pg_catalog	pg_rewrite	121	630784	32768	466944	131072	616 kB	32 kB	456 kB	128 kB
2609	pg_catalog	pg_description	4284	565248	196608	8192	360448	552 kB	192 kB	8192 bytes	352 kB
16929	public	search_tag	1320	557056	409600		147456	544 kB	400 kB		144 kB
16639	public	people_db_abarating	2408	499712	294912		204800	488 kB	288 kB		200 kB
16399	public	alerts_realtimequeue	12	466944	425984		40960	456 kB	416 kB		40 kB

Gonna take a look at indexes next since I know we have a lot of them we can probably remove.

[mlissner]

Here's what the index table looks like:

WITH table_scans as (
    SELECT relid,
        tables.idx_scan + tables.seq_scan as all_scans,
        ( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
                pg_relation_size(relid) as table_size
        FROM pg_stat_user_tables as tables
),
all_writes as (
    SELECT sum(writes) as total_writes
    FROM table_scans
),
indexes as (
    SELECT idx_stat.relid, idx_stat.indexrelid,
        idx_stat.schemaname, idx_stat.relname as tablename,
        idx_stat.indexrelname as indexname,
        idx_stat.idx_scan,
        pg_relation_size(idx_stat.indexrelid) as index_bytes,
        indexdef ~* 'USING btree' AS idx_is_btree
    FROM pg_stat_user_indexes as idx_stat
        JOIN pg_index
            USING (indexrelid)
        JOIN pg_indexes as indexes
            ON idx_stat.schemaname = indexes.schemaname
                AND idx_stat.relname = indexes.tablename
                AND idx_stat.indexrelname = indexes.indexname
    WHERE pg_index.indisunique = FALSE
),
index_ratios AS (
SELECT schemaname, tablename, indexname,
    idx_scan, all_scans,
    round(( CASE WHEN all_scans = 0 THEN 0.0::NUMERIC
        ELSE idx_scan::NUMERIC/all_scans * 100 END),2) as index_scan_pct,
    writes,
    round((CASE WHEN writes = 0 THEN idx_scan::NUMERIC ELSE idx_scan::NUMERIC/writes END),2)
        as scans_per_write,
    pg_size_pretty(index_bytes) as index_size,
    pg_size_pretty(table_size) as table_size,
    idx_is_btree, index_bytes
    FROM indexes
    JOIN table_scans
    USING (relid)
),
index_groups AS (
SELECT 'Never Used Indexes' as reason, *, 1 as grp
FROM index_ratios
WHERE
    idx_scan = 0
    and idx_is_btree
UNION ALL
SELECT 'Low Scans, High Writes' as reason, *, 2 as grp
FROM index_ratios
WHERE
    scans_per_write <= 1
    and index_scan_pct < 10
    and idx_scan > 0
    and writes > 100
    and idx_is_btree
UNION ALL
SELECT 'Seldom Used Large Indexes' as reason, *, 3 as grp
FROM index_ratios
WHERE
    index_scan_pct < 5
    and scans_per_write > 1
    and idx_scan > 0
    and idx_is_btree
    and index_bytes > 100000000
UNION ALL
SELECT 'High-Write Large Non-Btree' as reason, index_ratios.*, 4 as grp 
FROM index_ratios, all_writes
WHERE
    ( writes::NUMERIC / ( total_writes + 1 ) ) > 0.02
    AND NOT idx_is_btree
    AND index_bytes > 100000000
ORDER BY grp, index_bytes DESC )
SELECT reason, schemaname, tablename, indexname,
    index_scan_pct, scans_per_write, index_size, table_size
FROM index_groups;

reason	schemaname	tablename	indexname	index_scan_pct	scans_per_write	index_size	table_size
Never Used Indexes	public	search_recapdocument	search_recapdocument_filepath_local_7dc6b0e53ccf753_like	0.00	0.00	11 GB	26 GB
Never Used Indexes	public	search_recapdocument	search_recapdocument_b4e48d82	0.00	0.00	9518 MB	26 GB
Never Used Indexes	public	search_recapdocument	search_recapdocument_86559dba	0.00	0.00	9507 MB	26 GB
Never Used Indexes	public	search_docketentry	search_docketentry_recap_sequence_number_d700f0391e8213a_like	0.00	0.00	9473 MB	36 GB
Never Used Indexes	public	search_docketentry	search_docketentry_bff4d47b	0.00	0.00	9472 MB	36 GB
Never Used Indexes	public	search_docket	search_docket_ia_upload_failure_count_28fe663d91d7ffbb_idx	0.00	0.00	9417 MB	17 GB
Never Used Indexes	public	search_docketentry	search_docketentry_eb19fcf7	0.00	0.00	8460 MB	36 GB
Never Used Indexes	public	search_docket	search_docket_695b63bb	0.00	0.00	5307 MB	17 GB
Never Used Indexes	public	search_docket	search_docket_61326117	0.00	0.00	5260 MB	17 GB
Never Used Indexes	public	search_docket	search_docket_f9b591e1	0.00	0.00	5210 MB	17 GB
Never Used Indexes	public	lasc_action	lasc_action_docket_id_97937003	0.00	0.00	3389 MB	12 GB
Never Used Indexes	public	lasc_documentfiled	lasc_documentfiled_docket_id_ae29caa0	0.00	0.00	2863 MB	7603 MB
Never Used Indexes	public	lasc_action	lasc_action_date_created_4b47e989	0.00	0.00	2727 MB	12 GB
Never Used Indexes	public	lasc_action	lasc_action_date_modified_1abed903	0.00	0.00	2727 MB	12 GB
Never Used Indexes	public	people_db_attorney	people_db_attorney_contact_raw_4f8ea24a8a6126ce_like	0.00	0.00	2577 MB	1801 MB
Never Used Indexes	public	people_db_attorney	people_db_attorney_89638369	0.00	0.00	2569 MB	1801 MB
Never Used Indexes	public	lasc_documentfiled	lasc_documentfiled_date_modified_cc6080c9	0.00	0.00	2229 MB	7603 MB
Never Used Indexes	public	lasc_documentfiled	lasc_documentfiled_date_created_6b2a89bb	0.00	0.00	2229 MB	7603 MB
Never Used Indexes	public	recap_rss_rssfeedstatus	recap_rss_rssfeedstatus_7a46e69c	0.00	0.00	1876 MB	144 MB
Never Used Indexes	public	recap_rss_rssfeedstatus	recap_rss_rssfeedstatus_court_id_41df24dc437f861a_like	0.00	0.00	1875 MB	144 MB
Never Used Indexes	public	recap_rss_rssfeedstatus	recap_rss_rssfeedstatus_5fdb3d66	0.00	0.00	1672 MB	144 MB
Never Used Indexes	public	recap_rss_rssfeedstatus	recap_rss_rssfeedstatus_9acb4454	0.00	0.00	1314 MB	144 MB
Never Used Indexes	public	people_db_role	people_db_role_29a7e964	0.00	0.00	1225 MB	1630 MB
Never Used Indexes	public	search_opinion	search_opinion_local_path_63290b39b28ef927_like	0.00	0.00	1222 MB	4451 MB
Never Used Indexes	public	search_opinion	search_opinion_download_url_3b11b165f23bc568_like	0.00	0.00	1220 MB	4451 MB
Never Used Indexes	public	search_opinion	search_opinion_1cbcfc0f	0.00	0.00	1210 MB	4451 MB
Never Used Indexes	public	search_opinion	search_opinion_71485e76	0.00	0.00	1203 MB	4451 MB
Never Used Indexes	public	lasc_queuedpdf	lasc_queuedpdf_internal_case_id_ceffd139_like	0.00	0.00	1097 MB	1465 MB
Never Used Indexes	public	lasc_queuedpdf	lasc_queuedpdf_internal_case_id_ceffd139	0.00	0.00	1096 MB	1465 MB
Never Used Indexes	public	search_bankruptcyinformation	search_bankruptcyinformation_date_modified_c1b76dd9	0.00	0.00	1091 MB	2310 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_defendant_1917b677dad9291b_uniq	0.00	0.00	1020 MB	3296 MB
Never Used Indexes	public	search_bankruptcyinformation	search_bankruptcyinformation_date_created_60f180b0	0.00	0.00	939 MB	2310 MB
Never Used Indexes	public	search_docketentry_tags	search_docketentry_tags_76f094bc	0.00	0.00	918 MB	2463 MB
Never Used Indexes	public	lasc_queuedpdf	lasc_queuedpdf_document_id_5ef0503b_like	0.00	0.00	859 MB	1465 MB
Never Used Indexes	public	lasc_queuedpdf	lasc_queuedpdf_document_id_5ef0503b	0.00	0.00	856 MB	1465 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_plaintiff_3aba2127efcb646f_uniq	0.00	0.00	843 MB	3296 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_district_id_455568623a9da568_idx	0.00	0.00	775 MB	3296 MB
Never Used Indexes	public	people_db_partytype	people_db_partytype_bb2cb5a6	0.00	0.00	751 MB	887 MB
Never Used Indexes	public	lasc_queuedpdf	lasc_queuedpdf_docket_id_5fbbd00a	0.00	0.00	750 MB	1465 MB
Never Used Indexes	public	lasc_documentimage	lasc_documentimage_docket_id_0b435bed	0.00	0.00	741 MB	3229 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_section_73d9a83f15a49cf7_uniq	0.00	0.00	677 MB	3296 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_subsection_6d4a1e238eb3d830_uniq	0.00	0.00	668 MB	3296 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_title_237ea2ba12345066_uniq	0.00	0.00	667 MB	3296 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_3acc614b	0.00	0.00	666 MB	3296 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_circuit_id_6c29143a8524f734_like	0.00	0.00	666 MB	3296 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_a34a99d3	0.00	0.00	666 MB	3296 MB
Never Used Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_district_id_422635be62a49e48_like	0.00	0.00	665 MB	3296 MB
Never Used Indexes	public	people_db_attorney	people_db_attorney_5fdb3d66	0.00	0.00	616 MB	1801 MB
Never Used Indexes	public	lasc_party	lasc_party_docket_id_eefccc6e	0.00	0.00	583 MB	1792 MB
Never Used Indexes	public	lasc_party	lasc_party_date_created_ac942438	0.00	0.00	570 MB	1792 MB
Never Used Indexes	public	lasc_party	lasc_party_date_modified_a3c545ea	0.00	0.00	570 MB	1792 MB
Never Used Indexes	public	lasc_documentimage	lasc_documentimage_date_modified_3426d953	0.00	0.00	569 MB	3229 MB
Never Used Indexes	public	lasc_documentimage	lasc_documentimage_date_created_0f0e5cb0	0.00	0.00	564 MB	3229 MB
Never Used Indexes	public	lasc_queuedpdf	lasc_queuedpdf_date_modified_ed856b05	0.00	0.00	561 MB	1465 MB
Never Used Indexes	public	lasc_queuedpdf	lasc_queuedpdf_date_created_7ed0bfc0	0.00	0.00	561 MB	1465 MB
Never Used Indexes	public	lasc_proceeding	lasc_proceeding_docket_id_5722e146	0.00	0.00	517 MB	2181 MB
Never Used Indexes	public	lasc_proceeding	lasc_proceeding_date_created_f283822f	0.00	0.00	509 MB	2181 MB
Never Used Indexes	public	lasc_proceeding	lasc_proceeding_date_modified_c0959a18	0.00	0.00	509 MB	2181 MB
Never Used Indexes	public	search_opinion	search_opinion_bded6737	0.00	0.00	500 MB	4451 MB
Never Used Indexes	public	people_db_attorney	people_db_attorney_c69e55a4	0.00	0.00	498 MB	1801 MB
Never Used Indexes	public	people_db_partytype	people_db_partytype_name_4cb81702de26fee8_like	0.00	0.00	484 MB	887 MB
Never Used Indexes	public	people_db_partytype	people_db_partytype_b068931c	0.00	0.00	484 MB	887 MB
Never Used Indexes	public	people_db_party	people_db_party_bb2cb5a6	0.00	0.00	329 MB	814 MB
Never Used Indexes	public	people_db_party	people_db_party_extra_info_7a50cbcc44fd5d7a_like	0.00	0.00	328 MB	814 MB
Never Used Indexes	public	recap_processingqueue	recap_processingqueue_pacer_doc_id_1a6b8a9884da356a_like	0.00	0.00	305 MB	702 MB
Never Used Indexes	public	people_db_party	people_db_party_5fdb3d66	0.00	0.00	300 MB	814 MB
Never Used Indexes	public	people_db_party	people_db_party_c69e55a4	0.00	0.00	300 MB	814 MB
Never Used Indexes	public	search_opinioncluster	search_opinioncluster_precedential_status_2bdec6e2dedba28b_like	0.00	0.00	278 MB	1366 MB
Never Used Indexes	public	search_opinioncluster	search_opinioncluster_f796c05b	0.00	0.00	278 MB	1366 MB
Never Used Indexes	public	search_opinioncluster	search_opinioncluster_filepath_json_harvard_4b8057d0_like	0.00	0.00	218 MB	1366 MB
Never Used Indexes	public	search_opinioncluster	search_opinioncluster_filepath_json_harvard_4b8057d0	0.00	0.00	217 MB	1366 MB
Never Used Indexes	public	scrapers_errorlog	scrapers_errorlog_court_id_73dcae0e0bc9f3ff_like	0.00	0.00	202 MB	10 MB
Never Used Indexes	public	lasc_docket	lasc_docket_docket_number_district_division_code_07584433_idx	0.00	0.00	143 MB	627 MB
Never Used Indexes	public	lasc_docket	lasc_docket_docket_number_0cb1db11_like	0.00	0.00	140 MB	627 MB
Never Used Indexes	public	lasc_docket	lasc_docket_docket_number_0cb1db11	0.00	0.00	140 MB	627 MB
Never Used Indexes	public	recap_pacerhtmlfiles	recap_pacerhtmlfiles_5fdb3d66	0.00	0.00	116 MB	519 MB
Never Used Indexes	public	recap_pacerhtmlfiles	recap_pacerhtmlfiles_c69e55a4	0.00	0.00	115 MB	519 MB
Never Used Indexes	public	lasc_docket	lasc_docket_date_checked_266e9264	0.00	0.00	74 MB	627 MB
Never Used Indexes	public	lasc_lascjson	lasc_lascjson_content_type_id_f929a00e	0.00	0.00	64 MB	332 MB
Never Used Indexes	public	lasc_docket	lasc_docket_date_created_0046364b	0.00	0.00	58 MB	627 MB
Never Used Indexes	public	lasc_docket	lasc_docket_date_modified_1185b783	0.00	0.00	58 MB	627 MB
Never Used Indexes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_pacer_case_id_21aa36c3_like	0.00	0.00	53 MB	92 MB
Never Used Indexes	public	lasc_lascjson	lasc_lascjson_date_created_c4be2182	0.00	0.00	50 MB	332 MB
Never Used Indexes	public	lasc_lascjson	lasc_lascjson_date_modified_69edb721	0.00	0.00	50 MB	332 MB
Never Used Indexes	public	recap_rss_rssfeeddata	recap_rss_rssfeeddata_date_modified_cfe95447	0.00	0.00	48 MB	269 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_b068931c	0.00	0.00	41 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_name_eddcefc5b671344_like	0.00	0.00	40 MB	123 MB
Never Used Indexes	public	lasc_crossreference	lasc_crossreference_docket_id_1078b88c	0.00	0.00	35 MB	67 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_address1_403814857b548870_like	0.00	0.00	33 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_81e70cb1	0.00	0.00	33 MB	123 MB
Never Used Indexes	public	lasc_crossreference	lasc_crossreference_date_created_fd96ff13	0.00	0.00	28 MB	67 MB
Never Used Indexes	public	lasc_crossreference	lasc_crossreference_date_modified_25a5050e	0.00	0.00	28 MB	67 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_city_2a5498a19c997008_like	0.00	0.00	25 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_4ed5d2ea	0.00	0.00	25 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_address2_403814857b4403d3_like	0.00	0.00	25 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_f669f8e9	0.00	0.00	25 MB	123 MB
Never Used Indexes	public	search_opinioncluster_panel	search_opinioncluster_panel_49bb60ae	0.00	0.00	24 MB	34 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_5fdb3d66	0.00	0.00	23 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_c69e55a4	0.00	0.00	23 MB	123 MB
Never Used Indexes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_status_19964cb1	0.00	0.00	23 MB	92 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_zip_code_66632293e4093e4e_like	0.00	0.00	21 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_0c0ae404	0.00	0.00	21 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_9ed39e2e	0.00	0.00	19 MB	123 MB
Never Used Indexes	public	people_db_attorneyorganization	people_db_attorneyorganization_state_18fe99f5bf671255_like	0.00	0.00	19 MB	123 MB
Never Used Indexes	public	search_claimhistory	search_claimhistory_filepath_local_c52db4fc	0.00	0.00	18 MB	44 MB
Never Used Indexes	public	search_claimhistory	search_claimhistory_filepath_local_c52db4fc_like	0.00	0.00	18 MB	44 MB
Never Used Indexes	public	search_claimhistory	search_claimhistory_is_sealed_80556d76	0.00	0.00	18 MB	44 MB
Never Used Indexes	public	search_claimhistory	search_claimhistory_is_free_on_pacer_81332a2c	0.00	0.00	18 MB	44 MB
Never Used Indexes	public	scrapers_pacerfreedocumentlog	scrapers_pacerfreedocumentlog_68f129b1	0.00	0.00	16 MB	24 MB
Never Used Indexes	public	lasc_lascpdf	lasc_lascpdf_document_id_a222b520	0.00	0.00	16 MB	60 MB
Never Used Indexes	public	lasc_lascpdf	lasc_lascpdf_document_id_a222b520_like	0.00	0.00	16 MB	60 MB
Never Used Indexes	public	search_claimhistory	search_claimhistory_date_modified_5f6ec339	0.00	0.00	14 MB	44 MB
Never Used Indexes	public	search_claimhistory	search_claimhistory_date_created_586d545e	0.00	0.00	14 MB	44 MB
Never Used Indexes	public	audio_audio	audio_audio_download_url_44408fffeee4f71b_like	0.00	0.00	14 MB	33 MB
Never Used Indexes	public	audio_audio	audio_audio_1cbcfc0f	0.00	0.00	13 MB	33 MB
Never Used Indexes	public	lasc_lascpdf	lasc_lascpdf_docket_number_f4f4d567	0.00	0.00	13 MB	60 MB
Never Used Indexes	public	lasc_lascpdf	lasc_lascpdf_docket_number_f4f4d567_like	0.00	0.00	13 MB	60 MB
Never Used Indexes	public	search_claim	search_claim_date_modified_f38130a2	0.00	0.00	12 MB	41 MB
Never Used Indexes	public	search_claim	search_claim_date_created_8c2e998c	0.00	0.00	11 MB	41 MB
Never Used Indexes	public	audio_audio	audio_audio_03b47046	0.00	0.00	10 MB	33 MB
Never Used Indexes	public	audio_audio	audio_audio_local_path_original_file_102ce483dde8495d_like	0.00	0.00	10 MB	33 MB
Never Used Indexes	public	audio_audio	audio_audio_41ddbca9	0.00	0.00	10000 kB	33 MB
Never Used Indexes	public	audio_audio	audio_audio_local_path_mp3_11f796e4872a9bad_like	0.00	0.00	9112 kB	33 MB
Never Used Indexes	public	lasc_lascpdf	lasc_lascpdf_filepath_local_c10c8db5	0.00	0.00	8928 kB	60 MB
Never Used Indexes	public	lasc_lascpdf	lasc_lascpdf_content_type_id_92b2954d	0.00	0.00	8800 kB	60 MB
Never Used Indexes	public	audio_audio	audio_audio_74a89174	0.00	0.00	7336 kB	33 MB
Never Used Indexes	public	scrapers_pacerfreedocumentrow	scrapers_pacerfreedocumentro_pacer_doc_id_11290bdaac19e210_like	0.00	0.00	7032 kB	75 MB
Never Used Indexes	public	lasc_lascpdf	lasc_lascpdf_date_created_01f9451f	0.00	0.00	6952 kB	60 MB
Never Used Indexes	public	lasc_lascpdf	lasc_lascpdf_date_modified_37f39ca4	0.00	0.00	6952 kB	60 MB
Never Used Indexes	public	disclosures_financialdisclosure	disclosures_financialdisclosure_filepath_8266edc6	0.00	0.00	5424 kB	20 MB
Never Used Indexes	public	disclosures_financialdisclosure	disclosures_financialdisclosure_filepath_8266edc6_like	0.00	0.00	5392 kB	20 MB
Never Used Indexes	public	alerts_alert	alerts_alert_5fdb3d66	0.00	0.00	3144 kB	1176 kB
Never Used Indexes	public	audio_audio_panel	audio_audio_panel_e7c5d788	0.00	0.00	2240 kB	3328 kB
Never Used Indexes	public	disclosures_reimbursement	disclosures_reimbursement_date_modified_3ca21f45	0.00	0.00	2040 kB	13 MB
Never Used Indexes	public	audio_audio_panel	audio_audio_panel_26f6023f	0.00	0.00	1832 kB	3328 kB
Never Used Indexes	public	lasc_queuedcase	lasc_queuedcase_internal_case_id_9e5b0a54_like	0.00	0.00	1536 kB	2328 kB
Never Used Indexes	public	lasc_queuedcase	lasc_queuedcase_internal_case_id_9e5b0a54	0.00	0.00	1536 kB	2328 kB
Never Used Indexes	public	alerts_docketalert	alerts_docketalert_c69e55a4	0.00	0.00	1432 kB	3296 kB
Never Used Indexes	public	stats_stat	stats_stat_name_6df421146f509d4_like	0.00	0.00	1304 kB	12 MB
Never Used Indexes	public	stats_stat	stats_stat_b068931c	0.00	0.00	1256 kB	12 MB
Never Used Indexes	public	search_claim_tags	search_claim_tags_tag_id_73b6bd4d	0.00	0.00	1256 kB	2344 kB
Never Used Indexes	public	people_db_position	people_db_position_7a46e69c	0.00	0.00	1136 kB	4432 kB
Never Used Indexes	public	disclosures_debt	disclosures_debt_date_modified_a1482a62	0.00	0.00	1104 kB	4840 kB
Never Used Indexes	public	people_db_person	people_db_person_2dbcba41	0.00	0.00	1104 kB	3744 kB
Never Used Indexes	public	people_db_person	people_db_person_slug_10074d278f243e42_like	0.00	0.00	1088 kB	3744 kB
Never Used Indexes	public	people_db_position	people_db_position_5fc7164b	0.00	0.00	1048 kB	4432 kB
Never Used Indexes	public	people_db_position	people_db_position_eae0a89e	0.00	0.00	1040 kB	4432 kB
Never Used Indexes	public	people_db_position	people_db_position_b070f947	0.00	0.00	1024 kB	4432 kB
Never Used Indexes	public	alerts_alert	alerts_alert_c69e55a4	0.00	0.00	1016 kB	1176 kB
Never Used Indexes	public	search_claim_tags	search_claim_tags_claim_id_2cf554b5	0.00	0.00	1008 kB	2344 kB
Never Used Indexes	public	lasc_queuedcase	lasc_queuedcase_date_modified_74609387	0.00	0.00	640 kB	2328 kB
Never Used Indexes	public	lasc_queuedcase	lasc_queuedcase_date_created_d0bc8b3c	0.00	0.00	640 kB	2328 kB
Never Used Indexes	public	people_db_person	people_db_person_e489b049	0.00	0.00	560 kB	3744 kB
Never Used Indexes	public	judges_school	judges_school_b068931c	0.00	0.00	376 kB	552 kB
Never Used Indexes	public	judges_school	judges_school_name_7efa31e36298c91e_like	0.00	0.00	376 kB	552 kB
Never Used Indexes	public	disclosures_spouseincome	disclosures_spouseincome_date_modified_9bea7dd2	0.00	0.00	368 kB	1736 kB
Never Used Indexes	public	people_db_school	people_db_school_b068931c	0.00	0.00	368 kB	496 kB
Never Used Indexes	public	favorites_favorite	favorites_favorite_c69e55a4	0.00	0.00	360 kB	1640 kB
Never Used Indexes	public	people_db_school	people_db_school_name_55359da037ff6cd5_like	0.00	0.00	360 kB	496 kB
Never Used Indexes	public	favorites_favorite	favorites_favorite_5fdb3d66	0.00	0.00	352 kB	1640 kB
Never Used Indexes	public	judges_school	judges_school_3c6ec45e	0.00	0.00	264 kB	552 kB
Never Used Indexes	public	people_db_school	people_db_school_3c6ec45e	0.00	0.00	240 kB	496 kB
Never Used Indexes	public	visualizations_scotusmap	visualizations_scotusmap_slug_4a427a002ca443db_like	0.00	0.00	232 kB	1200 kB
Never Used Indexes	public	visualizations_scotusmap	visualizations_scotusmap_2dbcba41	0.00	0.00	232 kB	1200 kB
Never Used Indexes	public	people_db_education	people_db_education_5fc7164b	0.00	0.00	224 kB	488 kB
Never Used Indexes	public	judges_school	judges_school_ffef75ef	0.00	0.00	216 kB	552 kB
Never Used Indexes	public	judges_school	judges_school_ffa9f914	0.00	0.00	216 kB	552 kB
Never Used Indexes	public	judges_school	judges_school_5fdb3d66	0.00	0.00	192 kB	552 kB
Never Used Indexes	public	judges_school	judges_school_c69e55a4	0.00	0.00	184 kB	552 kB
Never Used Indexes	public	people_db_school	people_db_school_ffef75ef	0.00	0.00	184 kB	496 kB
Never Used Indexes	public	donate_donation	donate_donation_5fdb3d66	0.00	0.00	160 kB	1688 kB
Never Used Indexes	public	disclosures_gift	disclosures_gift_date_modified_ceb7453c	0.00	0.00	152 kB	608 kB
Never Used Indexes	public	people_db_source	people_db_source_c69e55a4	0.00	0.00	152 kB	768 kB
Never Used Indexes	public	search_tag	search_tag_name_30c16b352387258b_like	0.00	0.00	112 kB	112 kB
Never Used Indexes	public	visualizations_scotusmap	visualizations_scotusmap_fcab374a	0.00	0.00	96 kB	1200 kB
Never Used Indexes	public	visualizations_scotusmap	visualizations_scotusmap_c69e55a4	0.00	0.00	96 kB	1200 kB
Never Used Indexes	public	visualizations_scotusmap	visualizations_scotusmap_5fdb3d66	0.00	0.00	96 kB	1200 kB
Never Used Indexes	public	visualizations_scotusmap	visualizations_scotusmap_b3d89bfd	0.00	0.00	88 kB	1200 kB
Never Used Indexes	public	visualizations_jsonversion	visualizations_jsonversion_5fdb3d66	0.00	0.00	88 kB	1880 kB
Never Used Indexes	public	visualizations_jsonversion	visualizations_jsonversion_c69e55a4	0.00	0.00	80 kB	1880 kB
Never Used Indexes	public	visualizations_referer	visualizations_referer_c69e55a4	0.00	0.00	56 kB	216 kB
Never Used Indexes	public	visualizations_referer	visualizations_referer_5fdb3d66	0.00	0.00	56 kB	216 kB
Never Used Indexes	public	search_tag	search_tag_5fdb3d66	0.00	0.00	56 kB	112 kB
Never Used Indexes	public	search_tag	search_tag_c69e55a4	0.00	0.00	56 kB	112 kB
Never Used Indexes	public	auth_group_permissions	auth_group_permissions_8373b171	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	donate_monthlydonation	donate_monthlydonation_5fdb3d66	0.00	0.00	16 kB	32 kB
Never Used Indexes	public	donate_monthlydonation	donate_monthlydonation_029df19e	0.00	0.00	16 kB	32 kB
Never Used Indexes	public	django_site	django_site_domain_a2e37b91_like	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	django_session	django_session_session_key_461cfeaa630ca218_like	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	django_session	django_session_de54fa62	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	auth_group_permissions	auth_group_permissions_0e939a4f	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	auth_group	auth_group_name_253ae2a6331666e8_like	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	auth_user_groups	auth_user_groups_e8701ad4	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	auth_user_groups	auth_user_groups_0e939a4f	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	lasc_tentativeruling	lasc_tentativeruling_docket_id_51a63aa6	0.00	0.00	16 kB	112 kB
Never Used Indexes	public	lasc_tentativeruling	lasc_tentativeruling_date_modified_11fea074	0.00	0.00	16 kB	112 kB
Never Used Indexes	public	lasc_tentativeruling	lasc_tentativeruling_date_created_577564e9	0.00	0.00	16 kB	112 kB
Never Used Indexes	public	favorites_dockettag	favorites_dockettag_tag_id_068a9e7e	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_dockettag	favorites_dockettag_docket_id_b227f907	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_usertag	favorites_usertag_user_id_31f1221a	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_usertag	favorites_usertag_published_cf9b0e8c	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_usertag	favorites_usertag_view_count_d653362f	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_usertag	favorites_usertag_name_f5fa2755_like	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_usertag	favorites_usertag_name_f5fa2755	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_usertag	favorites_usertag_date_modified_1a97910d	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_usertag	favorites_usertag_date_created_bf5fed81	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	favorites_usertag	favorites_usertag_user_id_name_54aef6fe_idx	0.00	0.00	16 kB	8192 bytes
Never Used Indexes	public	judges_source	judges_source_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_source	judges_source_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_career	judges_career_0ce67364	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_career	judges_career_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_career	judges_career_9f440bf0	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_career	judges_career_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_career	judges_career_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_flag_users	waffle_flag_users_flag_id_833c37b0	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_flag_users	waffle_flag_users_user_id_8026df9b	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	search_opinioncluster_non_participating_judges	search_opinioncluster_non_participating_judges_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_politician	judges_politician_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_politician	judges_politician_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_politician	judges_politician_c943ec03	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_politician	judges_politician_name_last_c73c9140880b9c4_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_flag	waffle_flag_created_4a6e8cef	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_flag	waffle_flag_name_8799ccdf_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_abarating	judges_abarating_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_abarating	judges_abarating_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_abarating	judges_abarating_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_sample	waffle_sample_name_26b507bc_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_sample	waffle_sample_created_76198bd5	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_politicalaffiliation	judges_politicalaffiliation_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_politicalaffiliation	judges_politicalaffiliation_66ff0dc7	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_politicalaffiliation	judges_politicalaffiliation_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_politicalaffiliation	judges_politicalaffiliation_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_workerstate	djcelery_workerstate_f129901a	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_workerstate	djcelery_workerstate_hostname_3900851044588416_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_periodictask	djcelery_periodictask_1dcd7040	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_periodictask	djcelery_periodictask_f3f0d72a	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_periodictask	djcelery_periodictask_name_47c621f8dc029d22_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	lib_note	lib_note_date_created_7cf4d151	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	lib_note	lib_note_date_modified_19d0820a	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_0ce67364	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_1301727a	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_22b8ff35	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_2a1c0b55	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_43e12164	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_7a183bc6	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	favorites_prayer	favorites_prayer_date_created_07aee6d0	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	favorites_prayer	favorites_prayer_date_created_user_id_status_880d7280_idx	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	favorites_prayer	favorites_prayer_recap_document_id_status_82e2dbbb_idx	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	favorites_prayer	favorites_prayer_recap_document_id_user_id_c5d30108_idx	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	scrapers_pacermobilepagedata	scrapers_pacermobilepagedata_date_last_mobile_crawl_809860f7	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	scrapers_pacermobilepagedata	scrapers_pacermobilepagedata_date_modified_0983a830	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	scrapers_pacermobilepagedata	scrapers_pacermobilepagedata_date_created_79d19dab	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_7a46e69c	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_a2289cae	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_a7ad19f8	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_a9962d2d	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_b070f947	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_d32bfe21	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_position	judges_position_ed551732	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	celery_tasksetmeta	celery_tasksetmeta_662f707d	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	celery_tasksetmeta	celery_tasksetmeta_taskset_id_24b26c359742c9ab_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge	judges_judge_slug_40cf5ec3e3c023d8_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge	judges_judge_name_last_17f6ad5b90d49620_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge	judges_judge_c943ec03	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge	judges_judge_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge	judges_judge_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge	judges_judge_3c6ec45e	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge	judges_judge_2dbcba41	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	people_db_retentionevent	people_db_retentionevent_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_retentionevent	judges_retentionevent_4e6b5ce9	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_retentionevent	judges_retentionevent_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_retentionevent	judges_retentionevent_bce5bd07	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_retentionevent	judges_retentionevent_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge_race	judges_judge_race_3f2f3687	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_judge_race	judges_judge_race_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	search_docket_panel	search_docket_panel_a8452ca7	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	recap_emailprocessingqueue_recap_documents	recap_emailprocessingqueue_emailprocessingqueue_id_896acbad	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_education	judges_education_5fc7164b	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_education	judges_education_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_education	judges_education_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_education	judges_education_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	celery_taskmeta	celery_taskmeta_662f707d	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	recap_emailprocessingqueue	recap_emailprocessingqueue_status_798f5968	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	recap_emailprocessingqueue	recap_emailprocessingqueue_uploader_id_32651a93	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	recap_emailprocessingqueue	recap_emailprocessingqueue_court_id_83f67bf3_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	recap_emailprocessingqueue	recap_emailprocessingqueue_court_id_83f67bf3	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	recap_emailprocessingqueue	recap_emailprocessingqueue_date_modified_0900d415	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	recap_emailprocessingqueue	recap_emailprocessingqueue_date_created_2f32c34d	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	celery_taskmeta	celery_taskmeta_task_id_1efd6ed1da631331_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_taskstate	djcelery_taskstate_662f707d	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_taskstate	djcelery_taskstate_863bb2ee	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_taskstate	djcelery_taskstate_9ed39e2e	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_taskstate	djcelery_taskstate_b068931c	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_taskstate	djcelery_taskstate_ce77e6ef	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_taskstate	djcelery_taskstate_name_4337b4449e8827d_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_taskstate	djcelery_taskstate_state_19cb9b39780e399c_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	djcelery_taskstate	djcelery_taskstate_task_id_29366bc6dcd6fd60_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_flag_groups	waffle_flag_groups_flag_id_c11c0c05	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_flag_groups	waffle_flag_groups_group_id_a97c4f66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_switch	waffle_switch_name_68a12dd8_like	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	waffle_switch	waffle_switch_created_c004e77e	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	people_db_retentionevent	people_db_retentionevent_4e6b5ce9	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	people_db_retentionevent	people_db_retentionevent_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_title	judges_title_e7c5d788	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_title	judges_title_c69e55a4	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_title	judges_title_5fdb3d66	0.00	0.00	8192 bytes	0 bytes
Never Used Indexes	public	judges_title	judges_title_0ce67364	0.00	0.00	8192 bytes	0 bytes
Low Scans, High Writes	public	search_recapdocument	search_recapdocument_document_type_303cccac79571217_idx	0.00	0.00	13 GB	26 GB
Low Scans, High Writes	public	search_recapdocument	search_recapdocument_pacer_doc_id_12ec9c122839e6aa_like	0.65	0.73	12 GB	26 GB
Low Scans, High Writes	public	search_recapdocument	search_recapdocument_filepath_local_7dc6b0e53ccf753_uniq	0.01	0.01	10 GB	26 GB
Low Scans, High Writes	public	search_docketentry	search_docketentry_recap_sequence_number_1c82e51988e2d89f_idx	0.00	0.00	9950 MB	36 GB
Low Scans, High Writes	public	search_recapdocument	search_recapdocument_document_number_6f825e81ddd11fde_uniq	0.00	0.00	9590 MB	26 GB
Low Scans, High Writes	public	search_recapdocument	search_recapdocument_1dec38a6	0.00	0.00	9504 MB	26 GB
Low Scans, High Writes	public	search_recapdocument	search_recapdocument_c69e55a4	0.00	0.00	8421 MB	26 GB
Low Scans, High Writes	public	search_recapdocument	search_recapdocument_5fdb3d66	0.00	0.00	8160 MB	26 GB
Low Scans, High Writes	public	search_docketentry	search_docketentry_c69e55a4	0.00	0.03	7326 MB	36 GB
Low Scans, High Writes	public	search_docketentry	search_docketentry_5fdb3d66	0.00	0.00	7324 MB	36 GB
Low Scans, High Writes	public	search_docket	search_docket_4f3b580f	0.00	0.00	5486 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_70bec8bd	0.00	0.00	5320 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_dc3f2df2	0.00	0.00	5319 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_40a9d293	0.00	0.00	5316 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_657961a4	0.00	0.00	5311 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_220746bf	0.00	0.00	5309 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_64cdae4d	0.00	0.03	5289 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_02c1725c	0.00	0.03	5135 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_0b869b2f	0.00	0.00	5116 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_court_id_2d2438b2594e74ba_like	0.00	0.00	4769 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_7a46e69c	0.01	0.09	4764 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_5fdb3d66	0.00	0.01	4240 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_docket_number_4af29e98dca38326_uniq	0.00	0.00	4208 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_docket_number_core_713b7b04e01f11d7_like	0.04	0.30	3866 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_c69e55a4	0.00	0.00	3525 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_6c91ba55	0.03	0.25	3479 MB	17 GB
Low Scans, High Writes	public	search_docket	search_docket_34894a03	0.07	0.62	2961 MB	17 GB
Low Scans, High Writes	public	search_opinionscited	search_opinionscited_depth_46bacaef	0.00	0.00	2580 MB	2623 MB
Low Scans, High Writes	public	people_db_role	people_db_role_2c662395	0.19	0.10	951 MB	1630 MB
Low Scans, High Writes	public	search_opinion	search_opinion_74a89174	0.00	0.00	641 MB	4451 MB
Low Scans, High Writes	public	people_db_attorney	people_db_attorney_b068931c	0.01	0.21	570 MB	1801 MB
Low Scans, High Writes	public	people_db_party	people_db_party_b068931c	0.07	0.76	525 MB	814 MB
Low Scans, High Writes	public	search_opinion	search_opinion_c69e55a4	0.00	0.68	442 MB	4451 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_11298d03	0.57	0.01	343 MB	702 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_40d913b2	0.40	0.01	340 MB	702 MB
Low Scans, High Writes	public	people_db_partytype	people_db_partytype_1427d4ab	1.18	0.99	322 MB	887 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_1427d4ab	0.00	0.00	322 MB	702 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_af76a535	0.04	0.00	297 MB	702 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_7a46e69c	0.00	0.00	290 MB	702 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_court_id_58a50ea026638d4b_like	3.33	0.06	289 MB	702 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_c69e55a4	0.00	0.00	268 MB	702 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_5fdb3d66	5.19	0.09	231 MB	702 MB
Low Scans, High Writes	public	search_opinioncluster	search_opinioncluster_0b869b2f	0.00	0.00	205 MB	1366 MB
Low Scans, High Writes	public	search_opinioncluster	search_opinioncluster_supreme_court_db_id_4297061ed6ba336_like	0.00	0.00	205 MB	1366 MB
Low Scans, High Writes	public	search_opinioncluster	search_opinioncluster_61326117	0.00	0.00	204 MB	1366 MB
Low Scans, High Writes	public	search_opinioncluster	search_opinioncluster_e0fd3ccf	0.00	0.00	203 MB	1366 MB
Low Scans, High Writes	public	search_opinioncluster	search_opinioncluster_d91c83eb	0.00	0.00	197 MB	1366 MB
Low Scans, High Writes	public	recap_processingqueue	recap_processingqueue_pacer_case_id_7602450bbf15145d_uniq	0.25	0.00	184 MB	702 MB
Low Scans, High Writes	public	search_opinioncluster	search_opinioncluster_c69e55a4	0.00	0.00	182 MB	1366 MB
Low Scans, High Writes	public	search_opinioncluster	search_opinioncluster_98cc5f59	0.00	0.01	181 MB	1366 MB
Low Scans, High Writes	public	search_opinioncluster	search_opinioncluster_5fdb3d66	0.01	0.53	171 MB	1366 MB
Low Scans, High Writes	public	search_citation	search_citation_volume_251bc1d270a8abee_idx	0.00	0.65	154 MB	218 MB
Low Scans, High Writes	public	search_citation	search_citation_966557f0	0.00	0.00	125 MB	218 MB
Low Scans, High Writes	public	disclosures_investment	disclosures_investment_date_modified_e2f8f841	0.00	0.00	98 MB	546 MB
Low Scans, High Writes	public	disclosures_investment	disclosures_investment_date_created_252beaa5	0.87	0.00	98 MB	546 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_date_completed_cfc17415	0.00	0.00	64 MB	92 MB
Low Scans, High Writes	public	recap_rss_rssfeeddata	recap_rss_rssfeeddata_court_id_8bd4988e	6.52	0.00	61 MB	269 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_pacer_case_id_21aa36c3	0.00	0.00	53 MB	92 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_user_id_a2c0c6f8	0.09	0.00	53 MB	92 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_court_id_1246ddd3_like	0.74	0.01	53 MB	92 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_court_id_1246ddd3	0.03	0.00	53 MB	92 MB
Low Scans, High Writes	public	django_cache	django_cache_expires	0.00	0.00	52 MB	177 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_docket_id_371bfcf0	0.00	0.00	52 MB	92 MB
Low Scans, High Writes	public	recap_rss_rssfeeddata	recap_rss_rssfeeddata_date_created_0b97403f	2.17	0.00	48 MB	269 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_recap_document_id_b9c23829	1.39	0.02	46 MB	92 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_date_created_e21b4d2e	0.00	0.00	43 MB	92 MB
Low Scans, High Writes	public	recap_pacerfetchqueue	recap_pacerfetchqueue_date_modified_d110c824	0.00	0.00	42 MB	92 MB
Low Scans, High Writes	public	recap_rss_rssitemcache	recap_rss_rssitemcache_c69e55a4	0.00	0.00	31 MB	32 MB
Low Scans, High Writes	public	search_claimhistory	search_claimhistory_document_number_6316c155_like	0.02	0.00	13 MB	44 MB
Low Scans, High Writes	public	search_claimhistory	search_claimhistory_document_number_6316c155	0.00	0.00	12 MB	44 MB
Low Scans, High Writes	public	scrapers_pacerfreedocumentlog	scrapers_pacerfreedocumentlog_7a46e69c	1.55	0.02	12 MB	24 MB
Low Scans, High Writes	public	search_claim	search_claim_claim_number_263236b3_like	7.01	0.14	11 MB	41 MB
Low Scans, High Writes	public	search_claim	search_claim_claim_number_263236b3	0.43	0.01	10 MB	41 MB
Low Scans, High Writes	public	audio_audio	audio_audio_sha1_2510d5a8f56f35d4_like	0.02	0.57	7336 kB	33 MB
Low Scans, High Writes	public	disclosures_financialdisclosure	disclosures_financialdisclosure_date_created_85a1e80e	0.00	0.00	3944 kB	20 MB
Low Scans, High Writes	public	disclosures_financialdisclosure	disclosures_financialdisclosure_date_modified_717ae8fa	0.00	0.00	3424 kB	20 MB
Low Scans, High Writes	public	audio_audio	audio_audio_0b869b2f	0.01	0.30	3032 kB	33 MB
Low Scans, High Writes	public	disclosures_financialdisclosure	disclosures_financialdisclosure_sha1_552f12ae_like	0.52	0.18	2896 kB	20 MB
Low Scans, High Writes	public	audio_audio	audio_audio_5fdb3d66	0.00	0.00	2848 kB	33 MB
Low Scans, High Writes	public	audio_audio	audio_audio_61326117	0.01	0.45	2288 kB	33 MB
Low Scans, High Writes	public	disclosures_financialdisclosure	disclosures_financialdisclosure_year_ee032263	0.00	0.00	2176 kB	20 MB
Low Scans, High Writes	public	disclosures_reimbursement	disclosures_reimbursement_date_created_4056c28a	0.37	0.00	2040 kB	13 MB
Low Scans, High Writes	public	disclosures_position	disclosures_position_date_created_e515f4be	0.36	0.00	2008 kB	9448 kB
Low Scans, High Writes	public	disclosures_position	disclosures_position_date_modified_01fafcba	0.00	0.00	2008 kB	9448 kB
Low Scans, High Writes	public	disclosures_debt	disclosures_debt_date_created_ed9d5440	0.24	0.00	1104 kB	4840 kB
Low Scans, High Writes	public	disclosures_financialdisclosure	disclosures_financialdisclosure_person_id_83e04c6c	0.01	0.00	976 kB	20 MB
Low Scans, High Writes	public	search_originatingcourtinformation	search_originatingcourtinformation_09a6c128	0.00	0.03	936 kB	1824 kB
Low Scans, High Writes	public	disclosures_noninvestmentincome	disclosures_noninvestmentincome_date_created_d876ac4b	0.20	0.01	888 kB	4368 kB
Low Scans, High Writes	public	disclosures_noninvestmentincome	disclosures_noninvestmentincome_date_modified_d3c68c8b	0.00	0.00	888 kB	4368 kB
Low Scans, High Writes	public	stats_stat	stats_stat_a6fb65b6	1.88	0.04	848 kB	12 MB
Low Scans, High Writes	public	search_originatingcourtinformation	search_originatingcourtinformation_02c1725c	0.00	0.03	808 kB	1824 kB
Low Scans, High Writes	public	search_originatingcourtinformation	search_originatingcourtinformation_5fdb3d66	0.00	0.03	800 kB	1824 kB
Low Scans, High Writes	public	search_originatingcourtinformation	search_originatingcourtinformation_c69e55a4	0.00	0.03	704 kB	1824 kB
Low Scans, High Writes	public	disclosures_agreement	disclosures_agreement_date_created_799a50fa	0.14	0.01	520 kB	3032 kB
Low Scans, High Writes	public	disclosures_agreement	disclosures_agreement_date_modified_cf46cbed	0.01	0.00	520 kB	3032 kB
Low Scans, High Writes	public	favorites_favorite	favorites_favorite_c1925f7a	0.18	0.09	416 kB	1640 kB
Low Scans, High Writes	public	disclosures_spouseincome	disclosures_spouseincome_date_created_00632eb5	0.19	0.00	368 kB	1736 kB
Low Scans, High Writes	public	visualizations_scotusmap	visualizations_scotusmap_89d95aa5	0.00	0.00	144 kB	1200 kB
Low Scans, High Writes	public	disclosures_gift	disclosures_gift_date_created_c3e030fc	0.08	0.01	144 kB	608 kB
Low Scans, High Writes	public	donate_donation	donate_donation_c69e55a4	0.01	0.22	120 kB	1688 kB
Low Scans, High Writes	public	visualizations_scotusmap	visualizations_scotusmap_e8701ad4	0.00	0.12	120 kB	1200 kB
Low Scans, High Writes	public	alerts_realtimequeue	alerts_realtimequeue_item_type_4ad9a16110c6c33c_like	0.44	0.01	88 kB	8192 bytes
Low Scans, High Writes	public	alerts_realtimequeue	alerts_realtimequeue_7f6bf686	5.59	0.08	88 kB	8192 bytes
Low Scans, High Writes	public	donate_monthlydonation	donate_monthlydonation_c69e55a4	0.17	0.63	16 kB	32 kB
Seldom Used Large Indexes	public	search_docketentry	search_docketentry_1427d4ab	0.16	3.55	5430 MB	36 GB
Seldom Used Large Indexes	public	search_recapdocument_tags	search_recapdocument_tags_fae26ff6	0.04	33.63	842 MB	2488 MB
Seldom Used Large Indexes	public	search_docketentry_tags	search_docketentry_tags_b02d089e	0.03	129.92	790 MB	2463 MB
Seldom Used Large Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_98cc5f59	0.00	7.00	715 MB	3296 MB
Seldom Used Large Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_5fdb3d66	0.01	608735.00	650 MB	3296 MB
Seldom Used Large Indexes	public	search_opinion	search_opinion_sha1_5887dd5d3475ad17_like	0.01	3.34	641 MB	4451 MB
Seldom Used Large Indexes	public	people_db_attorney	people_db_attorney_name_46d318a02757f6dd_like	0.06	1.53	607 MB	1801 MB
Seldom Used Large Indexes	public	people_db_party	people_db_party_name_3d12b76fe7f0ae1c_like	0.60	6.37	527 MB	814 MB
Seldom Used Large Indexes	public	recap_fjcintegrateddatabase	recap_fjcintegrateddatabase_c69e55a4	0.00	4.00	484 MB	3296 MB
Seldom Used Large Indexes	public	search_opinion	search_opinion_4f331e2f	0.02	12.10	484 MB	4451 MB
Seldom Used Large Indexes	public	search_opinion	search_opinion_5fdb3d66	0.04	21.78	309 MB	4451 MB
Seldom Used Large Indexes	public	search_citation	search_citation_volume_ae340b5b02e8912_idx	0.14	47.23	192 MB	218 MB
Seldom Used Large Indexes	public	search_opinioncluster	search_opinioncluster_1427d4ab	0.45	31.58	176 MB	1366 MB
Seldom Used Large Indexes	public	people_db_attorneyorganizationassociation	people_db_attorneyorganizationassociation_9f99f769	2.17	11.39	172 MB	259 MB
Seldom Used Large Indexes	public	people_db_attorneyorganizationassociation	people_db_attorneyorganizationassociation_1427d4ab	0.96	5.05	171 MB	259 MB
Seldom Used Large Indexes	public	search_citation	search_citation_reporter_1b48f47a0886ffdd_like	0.02	6.25	125 MB	218 MB

Django makes a lot of these by default. I'm really not sure how to remove them, though I looked into it previously.

[mlissner]

I just applied the SQL that corresponds with these migrations:

Applying lasc.0005_remove_indexes... FAKED
Applying people_db.0049_remove_indexes... FAKED
Applying recap_rss.0007_remove_indexes... FAKED
Applying search.0101_remove_indexes... FAKED

I was immediately able to reclaim about 30GB. Pretty good, though I had hoped for more.

[mlissner]

News! I checked today and AUTOVACUUM must have done its thing. On Friday we had:

↪ df
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/vg1-lv1--db      916G  794G   76G  92% /db-drive    <-- Better!

But today we have:

↪ df
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/vg1-lv1--db      916G  736G  134G  85% /db-drive  <-- Much better!!

Should have seen this coming! Still, we need more space if we're ever going to copy a table for something, but this is breathing room.

[mlissner]

Over in #1951, I just yanked a few more indexes. It happens quickly, and I made a lot of notes in search/migrations/0006_xyz.{py|sql}. That yielded about 50GB, as expected. We should have some breathing room for a bit.

[mlissner]

More tips for dealing with big indexes here: https://instagram-engineering.com/handling-growth-with-postgres-5-tips-from-instagram-d5d7e7ffdfcb

[mlissner]

More excellent tips here: https://hakibenita.com/postgresql-unused-index-size Discussed here: https://news.ycombinator.com/item?id=37294793