explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pHHg

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 42,825.151 ↑ 1.0 1 1

Aggregate (cost=412,324,247.31..412,324,247.34 rows=1 width=72) (actual time=42,825.151..42,825.151 rows=1 loops=1)

  • Buffers: shared hit=22,327,760 read=35 dirtied=4
  • I/O Timings: read=0.611
2. 78.442 42,825.146 ↓ 0.0 0 1

Index Scan using message_reference_log_pkey on invoice_list il (cost=0.29..412,324,242.94 rows=1,748 width=6) (actual time=42,825.146..42,825.146 rows=0 loops=1)

  • Index Cond: (id > '4127'::numeric)
  • Filter: (((status)::text = 'REJECTED'::text) AND (NOT (SubPlan 1)))
  • Rows Removed by Filter: 27,732
  • Buffers: shared hit=22,327,760 read=35 dirtied=4
  • I/O Timings: read=0.611
3.          

SubPlan (for Index Scan)

4. 42,746.704 42,746.704 ↑ 1.0 1 2,288

Seq Scan on outgoing_message om (cost=0.00..29,759.05 rows=1 width=37) (actual time=18.683..18.683 rows=1 loops=2,288)

  • Filter: (((il.exchange_id)::text = (reference)::text) AND ((outgoing_message_type_id = '4'::numeric) OR (outgoing_message_type_id = '5'::numeric)))
  • Rows Removed by Filter: 65,142
  • Buffers: shared hit=22,300,407
Planning time : 1.059 ms
Execution time : 42,825.292 ms