explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jfq : EPV without where

Settings
# exclusive inclusive rows x rows loops node
1. 31,923.987 104,790.390 ↓ 1.0 8,096,267 1

Seq Scan on epv (cost=0.00..55,905,460.66 rows=8,065,313 width=1,343) (actual time=2.125..104,790.390 rows=8,096,267 loops=1)

2.          

SubPlan (for Seq Scan)

3. 0.000 40,481.335 ↓ 0.0 0 8,096,267

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

4. 40,481.335 40,481.335 ↓ 0.0 0 8,096,267

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

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

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

6. 0.000 16,192.534 ↓ 0.0 0 8,096,267

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

7. 16,192.534 16,192.534 ↓ 0.0 0 8,096,267

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

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

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

9. 0.000 16,192.534 ↓ 0.0 0 8,096,267

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

10. 16,192.534 16,192.534 ↓ 0.0 0 8,096,267

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

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

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

Planning time : 0.215 ms
Execution time : 105,219.607 ms