explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rn1p

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 129.962 ↑ 10.0 10 1

Limit (cost=0.28..8,775.72 rows=100 width=197) (actual time=14.791..129.962 rows=10 loops=1)

2. 87.111 129.961 ↑ 17.3 10 1

Nested Loop (cost=0.28..15,181.79 rows=173 width=197) (actual time=14.790..129.961 rows=10 loops=1)

  • Join Filter: ((c.created_at < s.start_time) AND (((s.customer_id)::text = (c.person_id)::text) OR ((s.customer_id)::text = (c.customer_id)::text)))
  • Rows Removed by Join Filter: 652,106
3. 7.790 7.790 ↑ 1.1 3,506 1

Index Scan using test_compound_start_end_idx on session s (cost=0.28..1,051.06 rows=3,795 width=197) (actual time=0.069..7.790 rows=3,506 loops=1)

  • Index Cond: ((start_time IS NOT NULL) AND (end_time IS NOT NULL))
  • Filter: (NOT published)
4. 35.004 35.060 ↑ 1.0 186 3,506

Materialize (cost=0.00..13.79 rows=186 width=42) (actual time=0.000..0.010 rows=186 loops=3,506)

5. 0.056 0.056 ↑ 1.0 186 1

Seq Scan on customer c (cost=0.00..12.86 rows=186 width=42) (actual time=0.008..0.056 rows=186 loops=1)

Planning time : 0.369 ms
Execution time : 130.030 ms