explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ubjO

Settings
# exclusive inclusive rows x rows loops node
1. 585.230 27,555.748 ↑ 81.6 3,109 1

Hash Anti Join (cost=165.65..59,339.25 rows=253,565 width=1,326) (actual time=2,015.170..27,555.748 rows=3,109 loops=1)

  • Hash Cond: ((t.job_id)::text = (ticket_1.job_id)::text)
  • Buffers: shared hit=292436 read=98921 dirtied=1
  • I/O Timings: read=9643.199
2. 1,091.709 26,706.500 ↓ 8.2 2,134,099 1

Nested Loop (cost=120.38..55,856.66 rows=261,776 width=1,326) (actual time=206.524..26,706.500 rows=2,134,099 loops=1)

  • Buffers: shared hit=289105 read=97547 dirtied=1
  • I/O Timings: read=9389.541
3. 8.245 212.279 ↓ 210.1 4,622 1

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

  • Group Key: (ticket.job_id)::text
  • Buffers: shared hit=3436 read=1185
  • I/O Timings: read=196.881
4. 204.034 204.034 ↓ 210.1 4,622 1

Index Scan using idx_entity_op_created on ticket (cost=0.56..46.78 rows=22 width=37) (actual time=0.045..204.034 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=3436 read=1185
  • I/O Timings: read=196.881
5. 23,655.396 25,402.512 ↑ 1.4 462 4,622

Bitmap Heap Scan on ticket t (cost=73.55..2,530.36 rows=644 width=1,326) (actual time=0.445..5.496 rows=462 loops=4,622)

  • Recheck Cond: ((job_id)::text = (ticket.job_id)::text)
  • Heap Blocks: exact=311447
  • Buffers: shared hit=285669 read=96362 dirtied=1
  • I/O Timings: read=9192.660
6. 1,747.116 1,747.116 ↑ 1.4 465 4,622

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

  • Index Cond: ((job_id)::text = (ticket.job_id)::text)
  • Buffers: shared hit=34457 read=36127
  • I/O Timings: read=633.745
7. 1.764 264.018 ↓ 219.8 4,615 1

Hash (cost=45.01..45.01 rows=21 width=37) (actual time=264.018..264.018 rows=4,615 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 375kB
  • Buffers: shared hit=3331 read=1374
  • I/O Timings: read=253.658
8. 262.254 262.254 ↓ 219.8 4,615 1

Index Scan using idx_entity_op_created on ticket ticket_1 (cost=0.56..45.01 rows=21 width=37) (actual time=13.228..262.254 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=3331 read=1374
  • I/O Timings: read=253.658
Planning time : 0.764 ms
Execution time : 27,556.048 ms