explain.depesz.com

PostgreSQL's explain analyze made readable

Result: APmG

Settings
# exclusive inclusive rows x rows loops node
1. 5,687.278 72,049.059 ↓ 1.2 29,684,678 1

Gather Merge (cost=5,836,372.30..8,735,286.36 rows=24,846,100 width=8) (actual time=64,908.449..72,049.059 rows=29,684,678 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 6,325.744 66,361.781 ↑ 1.3 9,894,893 3 / 3

Sort (cost=5,835,372.28..5,866,429.90 rows=12,423,050 width=8) (actual time=64,810.149..66,361.781 rows=9,894,893 loops=3)

  • Sort Key: lex_docket_entry.id
  • Sort Method: external merge Disk: 181728kB
  • Worker 0: Sort Method: external merge Disk: 170592kB
  • Worker 1: Sort Method: external merge Disk: 170552kB
3. 4,393.325 60,036.037 ↑ 1.3 9,894,893 3 / 3

Parallel Hash Semi Join (cost=232,038.80..4,201,684.24 rows=12,423,050 width=8) (actual time=1,908.116..60,036.037 rows=9,894,893 loops=3)

  • Hash Cond: (lex_docket_entry.case_id = lex_case.id)
4. 53,739.839 53,739.839 ↑ 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.036..53,739.839 rows=9,971,900 loops=3)

5. 230.251 1,902.873 ↑ 1.3 488,793 3 / 3

Parallel Hash (cost=224,392.00..224,392.00 rows=611,744 width=4) (actual time=1,902.873..1,902.873 rows=488,793 loops=3)

  • Buckets: 2097152 Batches: 1 Memory Usage: 73792kB
6. 167.063 1,672.622 ↑ 1.3 488,793 3 / 3

Parallel Hash Anti Join (cost=13,027.24..224,392.00 rows=611,744 width=4) (actual time=7.710..1,672.622 rows=488,793 loops=3)

  • Hash Cond: (lex_case.id = positive_lex_case_tags.lex_case_id)
7. 1,498.038 1,498.038 ↑ 1.2 494,809 3 / 3

Parallel Seq Scan on lex_case (cost=0.00..203,617.48 rows=618,148 width=4) (actual time=0.037..1,498.038 rows=494,809 loops=3)

8. 2.309 7.521 ↑ 1.1 6,015 3 / 3

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

  • Buckets: 32768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1152kB
9. 4.819 5.212 ↑ 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=1.255..5.212 rows=6,015 loops=3)

  • Recheck Cond: (tag_id = 528)
  • Heap Blocks: exact=40
10. 0.393 0.393 ↓ 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=1.178..1.178 rows=18,046 loops=1)

  • Index Cond: (tag_id = 528)
Planning time : 1.439 ms
Execution time : 73,469.516 ms