explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lCCO

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 10,530.125 ↑ 1.0 1 1

Result (cost=2.10..2.11 rows=1 width=8) (actual time=10,530.125..10,530.125 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.021 10,530.122 ↑ 1.0 1 1

Result (cost=2.09..2.10 rows=1 width=8) (actual time=10,530.121..10,530.122 rows=1 loops=1)

4.          

Initplan (for Result)

5. 0.003 806.519 ↑ 1.0 1 1

Result (cost=0.85..0.86 rows=1 width=8) (actual time=806.518..806.519 rows=1 loops=1)

6.          

Initplan (for Result)

7. 0.003 806.516 ↑ 1.0 1 1

Limit (cost=0.43..0.85 rows=1 width=8) (actual time=806.515..806.516 rows=1 loops=1)

8. 806.513 806.513 ↑ 586,907.0 1 1

Index Scan using archive_event_start_time_13ebf3057b10d225_uniq on archive_event (cost=0.43..248,461.55 rows=586,907 width=8) (actual time=806.513..806.513 rows=1 loops=1)

  • Index Cond: (start_time IS NOT NULL)
  • Filter: (storage_id = 40)
  • Rows Removed by Filter: 449714
9. 0.005 9,723.582 ↑ 1.0 1 1

Result (cost=1.21..1.22 rows=1 width=8) (actual time=9,723.582..9,723.582 rows=1 loops=1)

10.          

Initplan (for Result)

11. 0.002 9,723.577 ↑ 1.0 1 1

Limit (cost=0.69..1.21 rows=1 width=8) (actual time=9,723.577..9,723.577 rows=1 loops=1)

12. 9,723.575 9,723.575 ↑ 3,887,488.0 1 1

Index Only Scan using archive_recpart_until_60988c3b1b2d0ea3_idx on archive_recpart (cost=0.69..2,042,866.35 rows=3,887,488 width=8) (actual time=9,723.575..9,723.575 rows=1 loops=1)

  • Index Cond: (until IS NOT NULL)
  • Filter: (filepath ~~ '/media/storage/40%'::text)
  • Rows Removed by Filter: 7858363
  • Heap Fetches: 5914101
Planning time : 0.640 ms
Execution time : 10,530.220 ms