explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vnm5

Settings
# exclusive inclusive rows x rows loops node
1. 5,897.017 58,116.035 ↓ 1.9 29,684,678 1

Gather Merge (cost=4,932,342.91..6,759,145.65 rows=15,657,216 width=8) (actual time=50,648.241..58,116.035 rows=29,684,678 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6,461.357 52,219.018 ↓ 1.3 9,894,893 3 / 3

Sort (cost=4,931,342.88..4,950,914.40 rows=7,828,608 width=8) (actual time=50,561.567..52,219.018 rows=9,894,893 loops=3)

  • Sort Key: lex_docket_entry.id
  • Sort Method: external merge Disk: 181928kB
  • Worker 0: Sort Method: external merge Disk: 170328kB
  • Worker 1: Sort Method: external merge Disk: 170624kB
3. 2,744.269 45,757.661 ↓ 1.3 9,894,893 3 / 3

Parallel Hash Anti Join (cost=13,027.24..3,927,921.07 rows=7,828,608 width=8) (actual time=4.108..45,757.661 rows=9,894,893 loops=3)

  • Hash Cond: (lex_docket_entry.case_id = positive_lex_case_tags.lex_case_id)
4. 43,009.542 43,009.542 ↑ 1.2 9,971,900 3 / 3

Parallel Seq Scan on lex_docket_entry (cost=0.00..3,798,828.50 rows=12,423,050 width=12) (actual time=0.043..43,009.542 rows=9,971,900 loops=3)

5. 2.324 3.850 ↑ 1.1 6,015 3 / 3

Parallel Hash (cost=12,947.20..12,947.20 rows=6,403 width=8) (actual time=3.850..3.850 rows=6,015 loops=3)

  • Buckets: 32768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1152kB
6. 1.211 1.526 ↑ 1.1 6,015 3 / 3

Parallel Bitmap Heap Scan on positive_lex_case_tags (cost=343.53..12,947.20 rows=6,403 width=8) (actual time=0.354..1.526 rows=6,015 loops=3)

  • Recheck Cond: (tag_id = 528)
  • Heap Blocks: exact=79
7. 0.315 0.315 ↓ 1.2 18,046 1 / 3

Bitmap Index Scan on ix_positive_lex_case_tags_tag_id (cost=0.00..339.69 rows=15,368 width=0) (actual time=0.946..0.946 rows=18,046 loops=1)

  • Index Cond: (tag_id = 528)
Planning time : 0.329 ms
Execution time : 59,582.475 ms