explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 79d4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.278 392.808 ↑ 1.0 1 1

Aggregate (cost=26,797.93..26,797.94 rows=1 width=8) (actual time=392.808..392.808 rows=1 loops=1)

2. 1.451 392.530 ↑ 543.7 1,500 1

Nested Loop (cost=0.55..24,759.02 rows=815,565 width=0) (actual time=0.283..392.530 rows=1,500 loops=1)

3. 0.685 1.079 ↓ 1.5 1,500 1

Result (cost=0.00..25.02 rows=1,000 width=32) (actual time=0.004..1.079 rows=1,500 loops=1)

4. 0.393 0.394 ↓ 1.5 1,500 1

ProjectSet (cost=0.00..5.02 rows=1,000 width=4) (actual time=0.002..0.394 rows=1,500 loops=1)

5. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=1)

6. 0.000 390.000 ↑ 5.0 1 1,500

Append (cost=0.55..24.67 rows=5 width=8) (actual time=0.218..0.260 rows=1 loops=1,500)

7. 390.000 390.000 ↑ 5.0 1 1,500

Index Scan using event_series_created_on_key_1 on event_series_partitioned_customer_1 (cost=0.55..24.65 rows=5 width=8) (actual time=0.217..0.260 rows=1 loops=1,500)

  • Index Cond: ((CURRENT_TIMESTAMP <@ valid) AND (entity_id = ((((generate_series(1, 1500)))::text || '_1'::text))))
  • Filter: (customer_id = '1'::text)
Planning time : 0.786 ms
Execution time : 392.873 ms