explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GlpB

Settings
# exclusive inclusive rows x rows loops node
1. 0.137 65.005 ↑ 1.0 1,000 1

Limit (cost=0.00..5,042.38 rows=1,000 width=811) (actual time=0.022..65.005 rows=1,000 loops=1)

2. 64.868 64.868 ↑ 60.8 1,000 1

Seq Scan on bill_charge (cost=0.00..306,611.78 rows=60,807 width=811) (actual time=0.021..64.868 rows=1,000 loops=1)

  • Filter: ((charge_group)::text = 'OPE'::text)
  • Rows Removed by Filter: 76085
Planning time : 0.257 ms
Execution time : 65.132 ms