explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uue6

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 11,516.572 ↑ 1.0 1 1

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

2.          

Initplan (for Result)

3. 0.017 11,516.567 ↑ 1.0 1 1

Result (cost=2.09..2.10 rows=1 width=8) (actual time=11,516.567..11,516.567 rows=1 loops=1)

4.          

Initplan (for Result)

5. 0.005 685.199 ↑ 1.0 1 1

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

6.          

Initplan (for Result)

7. 0.002 685.194 ↑ 1.0 1 1

Limit (cost=0.43..0.85 rows=1 width=8) (actual time=685.193..685.194 rows=1 loops=1)

8. 685.192 685.192 ↑ 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=685.192..685.192 rows=1 loops=1)

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

Result (cost=1.21..1.22 rows=1 width=8) (actual time=10,831.350..10,831.351 rows=1 loops=1)

10.          

Initplan (for Result)

11. 0.002 10,831.345 ↑ 1.0 1 1

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

12. 10,831.343 10,831.343 ↑ 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=10,831.343..10,831.343 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.584 ms
Execution time : 11,516.618 ms