explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YLMQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9,969.423 ↑ 1.0 1 1

Result (cost=1,218,845.34..1,218,845.35 rows=1 width=8) (actual time=9,969.423..9,969.423 rows=1 loops=1)

  • Recheck Cond: (storage_id = 37)
  • Heap Blocks: exact=125639
  • Index Cond: (storage_id = 37)
  • Filter: (filepath ~~ '/media/storage//media/storage/37%'::text)
  • Rows Removed by Filter: 28143794
2. 761.396 761.396 ↑ 1.0 1 1

Aggregate (cost=163,280.67..163,280.68 rows=1 width=8) (actual time=761.396..761.396 rows=1 loops=1)

3. 627.663 627.663 ↓ 1.0 339,318 1

Bitmap Heap Scan on archive_event (cost=5,028.32..155,888.23 rows=328,553 width=8) (actual time=187.073..627.663 rows=339,318 loops=1)

4. 124.988 124.988 ↓ 1.1 345,206 1

Bitmap Index Scan on archive_event_f733a512 (cost=0.00..4,946.18 rows=328,553 width=0) (actual time=124.988..124.988 rows=345,206 loops=1)

5. 726.011 726.011 ↓ 1.0 339,318 1

CTE Scan on times (cost=0.00..6,571.06 rows=328,553 width=8) (actual time=187.076..726.011 rows=339,318 loops=1)

6. 9,208.021 9,208.021 ↑ 1.0 1 1

Aggregate (cost=1,055,564.65..1,055,564.66 rows=1 width=8) (actual time=9,208.021..9,208.021 rows=1 loops=1)

7. 9,208.016 9,208.016 ↓ 0.0 0 1

Seq Scan on archive_recpart (cost=0.00..1,055,500.25 rows=2,862 width=8) (actual time=9,208.016..9,208.016 rows=0 loops=1)

8. 9,208.016 9,208.016 ↓ 0.0 0 1

CTE Scan on untils (cost=0.00..57.24 rows=2,862 width=8) (actual time=9,208.016..9,208.016 rows=0 loops=1)

Planning time : 0.346 ms
Execution time : 9,974.982 ms