explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bFeB : epv with json wheres

Settings
# exclusive inclusive rows x rows loops node
1. 28,723.492 101,587.951 ↓ 1.0 8,096,051 1

Seq Scan on epv (cost=0.00..56,105,255.54 rows=8,065,044 width=1,343) (actual time=2.127..101,587.951 rows=8,096,051 loops=1)

  • Filter: (status = 'PRNT'::text)
  • Rows Removed by Filter: 216
2.          

SubPlan (for Seq Scan)

3. 8,096.051 40,480.255 ↓ 0.0 0 8,096,051

Result (cost=0.01..2.28 rows=100 width=32) (actual time=0.005..0.005 rows=0 loops=8,096,051)

4. 0.000 32,384.204 ↓ 0.0 0 8,096,051

ProjectSet (cost=0.01..0.53 rows=100 width=32) (actual time=0.004..0.004 rows=0 loops=8,096,051)

5. 32,384.204 32,384.204 ↓ 0.0 0 8,096,051

Result (cost=0.01..0.02 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=8,096,051)

  • One-Time Filter: (jsonb_array_length((epv.record -> 'absenceAmt'::text)) > 0)
6. 0.000 16,192.102 ↓ 0.0 0 8,096,051

Result (cost=0.01..2.28 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=8,096,051)

7. 0.000 16,192.102 ↓ 0.0 0 8,096,051

ProjectSet (cost=0.01..0.53 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=8,096,051)

8. 16,192.102 16,192.102 ↓ 0.0 0 8,096,051

Result (cost=0.01..0.02 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=8,096,051)

  • One-Time Filter: (jsonb_array_length((epv.record -> 'capdedn'::text)) > 0)
9. 0.000 16,192.102 ↓ 0.0 0 8,096,051

Result (cost=0.01..2.28 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=8,096,051)

10. 0.000 16,192.102 ↓ 0.0 0 8,096,051

ProjectSet (cost=0.01..0.53 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=8,096,051)

11. 16,192.102 16,192.102 ↓ 0.0 0 8,096,051

Result (cost=0.01..0.02 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=8,096,051)

  • One-Time Filter: (jsonb_array_length((epv.record -> 'othearn'::text)) > 0)
Planning time : 0.244 ms
Execution time : 102,084.215 ms