explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pUGa

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 0.073 ↑ 1.5 2 1

Nested Loop Left Join (cost=0.00..38.20 rows=3 width=2,767) (actual time=0.065..0.073 rows=2 loops=1)

  • Join Filter: (cdr.routing_service_sk = rs.routing_service_sk)
  • Rows Removed by Join Filter: 2
2. 0.002 0.026 ↑ 1.5 2 1

Append (cost=0.00..37.14 rows=3 width=400) (actual time=0.021..0.026 rows=2 loops=1)

3. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on dialogdetail_journal_20200501 cdr (cost=0.00..12.38 rows=1 width=400) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((channel_id)::text = 'Voice'::text)
4. 0.018 0.018 ↓ 2.0 2 1

Seq Scan on dialogdetail_journal_20200601 cdr_1 (cost=0.00..12.38 rows=1 width=400) (actual time=0.015..0.018 rows=2 loops=1)

  • Filter: ((channel_id)::text = 'Voice'::text)
5. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on dialogdetail_journal_20200701 cdr_2 (cost=0.00..12.38 rows=1 width=400) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((channel_id)::text = 'Voice'::text)
6. 0.009 0.014 ↓ 2.0 2 2

Materialize (cost=0.00..1.01 rows=1 width=2,367) (actual time=0.007..0.007 rows=2 loops=2)

7. 0.005 0.005 ↓ 2.0 2 1

Seq Scan on dim_routing_services rs (cost=0.00..1.01 rows=1 width=2,367) (actual time=0.004..0.005 rows=2 loops=1)

Planning time : 1.288 ms
Execution time : 0.248 ms