explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iTWc

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 42,322.165 ↑ 1.0 1 1

Result (cost=498.05..498.06 rows=1 width=8) (actual time=42,322.165..42,322.165 rows=1 loops=1)

2.          

Initplan (for Result)

3. 2.337 42,322.159 ↑ 1.0 1 1

Result (cost=498.03..498.05 rows=1 width=8) (actual time=42,322.158..42,322.159 rows=1 loops=1)

4.          

Initplan (for Result)

5. 0.001 1,028.635 ↑ 1.0 1 1

Result (cost=0.83..0.84 rows=1 width=8) (actual time=1,028.635..1,028.635 rows=1 loops=1)

6.          

Initplan (for Result)

7. 0.002 1,028.634 ↑ 1.0 1 1

Limit (cost=0.43..0.83 rows=1 width=8) (actual time=1,028.633..1,028.634 rows=1 loops=1)

8. 1,028.632 1,028.632 ↑ 623,577.0 1 1

Index Scan using archive_event_start_time_13ebf3057b10d225_uniq on archive_event (cost=0.43..247,960.42 rows=623,577 width=8) (actual time=1,028.632..1,028.632 rows=1 loops=1)

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

Result (cost=497.18..497.19 rows=1 width=8) (actual time=41,291.186..41,291.187 rows=1 loops=1)

10.          

Initplan (for Result)

11. 0.002 41,291.184 ↓ 0.0 0 1

Limit (cost=0.69..497.18 rows=1 width=8) (actual time=41,291.184..41,291.184 rows=0 loops=1)

12. 41,291.182 41,291.182 ↓ 0.0 0 1

Index Only Scan using archive_recpart_until_60988c3b1b2d0ea3_idx on archive_recpart (cost=0.69..1,420,973.02 rows=2,862 width=8) (actual time=41,291.182..41,291.182 rows=0 loops=1)

  • Index Cond: (until IS NOT NULL)
  • Filter: (filepath ~~ '/media/storage//media/storage/40%'::text)
  • Rows Removed by Filter: 28155547
  • Heap Fetches: 21677595
Planning time : 0.736 ms
Execution time : 42,322.345 ms