explain.depesz.com

PostgreSQL's explain analyze made readable

Result: huBU : EPV without joins

Settings
# exclusive inclusive rows x rows loops node
1. 29,940.982 175,669.900 ↓ 1.0 8,096,051 1

Seq Scan on epv (cost=0.00..55,923,792.05 rows=8,065,044 width=1,343) (actual time=5.385..175,669.900 rows=8,096,051 loops=1)

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

SubPlan (for Seq Scan)

3. 8,096.051 113,344.714 ↓ 0.0 0 8,096,051

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.014..0.014 rows=0 loops=8,096,051)

4. 105,248.663 105,248.663 ↓ 0.0 0 8,096,051

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.013..0.013 rows=0 loops=8,096,051)

5. 0.000 0.000 ↑ 1.0 1 8,096,051

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

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

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

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

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

8. 0.000 0.000 ↑ 1.0 1 8,096,051

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

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

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

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

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

11. 0.000 0.000 ↑ 1.0 1 8,096,051

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

Planning time : 50.687 ms
Execution time : 176,196.005 ms