explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mqye

Settings
# exclusive inclusive rows x rows loops node
1. 29.570 29.570 ↑ 1.1 11 1

Seq Scan on notification notificati0_ (cost=0.00..4,450.84 rows=12 width=530) (actual time=23.016..29.570 rows=11 loops=1)

  • Filter: (((status)::text = 'TO_BE_VALIDATED'::text) AND ((origin)::text = 'DISTRIBUTOR'::text))
  • Rows Removed by Filter: 33556
  • Buffers: shared hit=3276
Planning time : 2.009 ms
Execution time : 29.717 ms