explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KDrA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 941,821.787 ↑ 54.6 3,666 1

Limit (cost=1,001.60..369,238.57 rows=200,000 width=12) (actual time=8.476..941,821.787 rows=3,666 loops=1)

2. 0.000 942,262.808 ↑ 2,263.3 3,666 1

Gather Merge (cost=1,001.60..15,277,754.12 rows=8,297,240 width=12) (actual time=8.474..942,262.808 rows=3,666 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 5.568 2,301,177.435 ↑ 2,829.1 1,222 3

Nested Loop (cost=1.58..14,319,046.73 rows=3,457,183 width=12) (actual time=2.734..767,059.145 rows=1,222 loops=3)

4. 6.339 2,301,157.203 ↑ 2,829.1 1,222 3

Nested Loop (cost=1.43..13,766,400.78 rows=3,457,183 width=12) (actual time=2.708..767,052.401 rows=1,222 loops=3)

5. 6,840.644 2,300,941.902 ↑ 2,829.1 1,222 3

Nested Loop Anti Join (cost=1.00..12,079,857.02 rows=3,457,183 width=12) (actual time=2.193..766,980.634 rows=1,222 loops=3)

6. 1,456,324.734 1,456,324.734 ↓ 1.5 5,370,362 3

Parallel Index Scan Backward using ix_menu_needed_gavin_3 on docket_entry (cost=0.44..9,553,978.39 rows=3,482,484 width=12) (actual time=1.845..485,441.578 rows=5,370,362 loops=3)

  • Filter: (date_added >= '2018-11-22 23:13:00.077938'::timestamp without time zone)
  • Rows Removed by Filter: 1049024
7. 837,776.524 837,776.524 ↑ 178.0 1 16,111,087

Index Only Scan using ix_multiple_document_docket_entry_id on multiple_document (cost=0.57..28.43 rows=178 width=4) (actual time=0.052..0.052 rows=1 loops=16,111,087)

  • Index Cond: (docket_entry_id = docket_entry.id)
  • Heap Fetches: 16035795
8. 208.962 208.962 ↑ 1.0 1 3,666

Index Only Scan using iplc_case_id_terminated_on_court_id_idx on iplc_case (cost=0.43..0.49 rows=1 width=8) (actual time=0.057..0.057 rows=1 loops=3,666)

  • Index Cond: (id = docket_entry.case_id)
  • Heap Fetches: 3666
9. 14.664 14.664 ↑ 1.0 1 3,666

Index Scan using court_pkey on court (cost=0.14..0.16 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=3,666)

  • Index Cond: (id = iplc_case.court_id)