explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k9yD : test

Settings
# exclusive inclusive rows x rows loops node
1. 1,747.153 1,747.153 ↑ 26.0 1 1

Seq Scan on payslip (cost=10,000,000,000.00..10,000,460,065.12 rows=26 width=6) (actual time=156.358..1,747.153 rows=1 loops=1)

  • Filter: (ppsnumber = '8817012G'::bpchar)
  • Rows Removed by Filter: 141089
  • Buffers: shared hit=365221 read=93116 dirtied=359 written=344
Planning time : 0.086 ms
Execution time : 1,747.175 ms