explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QcWY

Settings
# exclusive inclusive rows x rows loops node
1. 379.792 379.792 ↑ 1.0 300,000 1

Seq Scan on TransactionLabels transactionlabels (cost=0..46,506 rows=305,220 width=36) (actual time=0.044..379.792 rows=300,000 loops=1)

  • Filter: (transactionlabels."ClassifierId" = 'Affordability'::text)
  • Buffers: shared hit=15,874 read=8,132
Planning time : 0.044 ms
Execution time : 545.032 ms