explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nDZ8

Settings
# exclusive inclusive rows x rows loops node
1. 664.507 664.507 ↓ 1.0 4,115,953 1

Seq Scan on a6421d95b0a34a9e8f9812e0af8929f0.payrunpayrollitem (cost=0.00..159,596.09 rows=4,108,244 width=52) (actual time=149.957..664.507 rows=4,115,953 loops=1)

  • Output: id, payrunid, payrollitemid, payrunstatus
  • Filter: (payrunpayrollitem.payrunid = '920453a8-89f8-47c7-b814-8aaf165a3181'::uuid)
  • Rows Removed by Filter: 2,348,294
  • Buffers: shared hit=78,793
Planning time : 0.062 ms
Execution time : 846.077 ms