explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4BC2

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 10.275 7,754.965 ↑ 42.1 3,109 1

Nested Loop (cost=165.36..56,810.82 rows=130,889 width=1,326) (actual time=1,734.886..7,754.965 rows=3,109 loops=1)

  • Buffers: shared hit=196237 read=195124 dirtied=1
  • I/O Timings: read=5764.093
2. 8.303 67.548 ↓ 210.1 4,622 1

HashAggregate (cost=46.83..47.05 rows=22 width=37) (actual time=62.610..67.548 rows=4,622 loops=1)

  • Group Key: (ticket_1.job_id)::text
  • Buffers: shared hit=3388 read=1233
  • I/O Timings: read=49.628
3. 59.245 59.245 ↓ 210.1 4,622 1

Index Scan using idx_entity_op_created on ticket ticket_1 (cost=0.56..46.78 rows=22 width=37) (actual time=0.046..59.245 rows=4,622 loops=1)

  • Index Cond: (((op_type)::text = 'SDD_SNAPSHOT'::text) AND ((entity_id)::text = 'sdb-services-test10:sdb17'::text))
  • Buffers: shared hit=3388 read=1233
  • I/O Timings: read=49.628
4. 7,066.197 7,677.142 ↑ 322.0 1 4,622

Bitmap Heap Scan on ticket (cost=118.53..2,576.95 rows=322 width=1,326) (actual time=1.660..1.661 rows=1 loops=4,622)

  • Recheck Cond: ((job_id)::text = (ticket_1.job_id)::text)
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 461
  • Heap Blocks: exact=311451
  • Buffers: shared hit=192849 read=193891 dirtied=1
  • I/O Timings: read=5714.464
5. 517.664 517.664 ↑ 1.4 465 4,622

Bitmap Index Scan on idx_job_op (cost=0.00..73.39 rows=644 width=0) (actual time=0.112..0.112 rows=465 loops=4,622)

  • Index Cond: ((job_id)::text = (ticket_1.job_id)::text)
  • Buffers: shared hit=13645 read=56939
  • I/O Timings: read=190.240
6.          

SubPlan (for Bitmap Heap Scan)

7. 93.281 93.281 ↓ 219.8 4,615 1

Index Scan using idx_entity_op_created on ticket ticket_2 (cost=0.56..45.01 rows=21 width=37) (actual time=0.094..93.281 rows=4,615 loops=1)

  • Index Cond: (((op_type)::text = 'SDD_COPY_EXTENT_COMPLETE'::text) AND ((entity_id)::text = 'sdb-services-test10:sdb17'::text))
  • Filter: ((status)::text = ANY ('{COMPLETED,ABORT}'::text[]))
  • Buffers: shared hit=3388 read=1317
  • I/O Timings: read=77.551
Planning time : 0.751 ms
Execution time : 7,755.257 ms