explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0gwQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 51,255.306 ↑ 1.0 1 1

Aggregate (cost=412,877,155.17..412,877,155.20 rows=1 width=72) (actual time=51,255.306..51,255.306 rows=1 loops=1)

  • Buffers: shared hit=15,342,245 read=6,197,548 dirtied=3
  • I/O Timings: read=10,821.341
2. 68.681 51,255.299 ↓ 0.0 0 1

Index Scan using message_reference_log_pkey on invoice_list il (cost=0.29..412,877,150.80 rows=1,748 width=6) (actual time=51,255.299..51,255.299 rows=0 loops=1)

  • Index Cond: (id > '4127'::numeric)
  • Filter: (((status)::text = 'REJECTED'::text) AND (NOT (SubPlan 1)))
  • Rows Removed by Filter: 27,850
  • Buffers: shared hit=15,342,245 read=6,197,548 dirtied=3
  • I/O Timings: read=10,821.341
3.          

SubPlan (for Index Scan)

4. 51,186.618 51,186.618 ↑ 1.0 1 2,289

Seq Scan on outgoing_message om (cost=0.00..29,768.88 rows=1 width=37) (actual time=22.362..22.362 rows=1 loops=2,289)

  • 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: 63,416
  • Buffers: shared hit=15,314,823 read=6,197,405
  • I/O Timings: read=10,819.299
Planning time : 0.934 ms
Execution time : 51,255.437 ms