explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pcJN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 42,319.646 ↑ 1.0 1 1

Result (cost=498.40..498.42 rows=1 width=8) (actual time=42,319.646..42,319.646 rows=1 loops=1)

  • Index Cond: (start_time IS NOT NULL)
  • Filter: (storage_id = 37)
  • Rows Removed by Filter: 20701
  • Index Cond: (until IS NOT NULL)
  • Filter: (filepath ~~ '/media/storage//media/storage/37%'::text)
  • Rows Removed by Filter: 28142681
  • Heap Fetches: 20894722
2. 42,319.641 42,319.641 ↑ 1.0 1 1

Result (cost=498.39..498.40 rows=1 width=8) (actual time=42,319.640..42,319.641 rows=1 loops=1)

3. 90.582 90.582 ↑ 1.0 1 1

Result (cost=1.18..1.19 rows=1 width=8) (actual time=90.582..90.582 rows=1 loops=1)

4. 90.578 90.578 ↑ 1.0 1 1

Limit (cost=0.43..1.18 rows=1 width=8) (actual time=90.577..90.578 rows=1 loops=1)

5. 90.576 90.576 ↑ 328,553.0 1 1

Index Scan using archive_event_start_time_13ebf3057b10d225_uniq on archive_event (cost=0.43..247,960.42 rows=328,553 width=8) (actual time=90.576..90.576 rows=1 loops=1)

6. 42,226.783 42,226.783 ↑ 1.0 1 1

Result (cost=497.18..497.19 rows=1 width=8) (actual time=42,226.782..42,226.783 rows=1 loops=1)

7. 42,226.778 42,226.778 ↓ 0.0 0 1

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

8. 42,226.776 42,226.776 ↓ 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=42,226.776..42,226.776 rows=0 loops=1)

Planning time : 1.456 ms
Execution time : 42,319.834 ms