explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Fj4

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.059 ↑ 1.5 2 1

Hash Join (cost=1.02..41.63 rows=3 width=2,735) (actual time=0.052..0.059 rows=2 loops=1)

  • Hash Cond: (cdr.routing_service_sk = rs.routing_service_sk)
2. 0.002 0.023 ↑ 300.0 2 1

Append (cost=0.00..39.00 rows=600 width=368) (actual time=0.018..0.023 rows=2 loops=1)

3. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on dialogdetail_journal_20200501 cdr (cost=0.00..12.00 rows=200 width=368) (actual time=0.010..0.010 rows=0 loops=1)

4. 0.008 0.008 ↑ 100.0 2 1

Seq Scan on dialogdetail_journal_20200601 cdr_1 (cost=0.00..12.00 rows=200 width=368) (actual time=0.007..0.008 rows=2 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on dialogdetail_journal_20200701 cdr_2 (cost=0.00..12.00 rows=200 width=368) (actual time=0.003..0.003 rows=0 loops=1)

6. 0.007 0.017 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=2,367) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.010 0.010 ↑ 1.0 1 1

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

  • Filter: ((channel_id)::text = 'Voice'::text)
  • Rows Removed by Filter: 1
Planning time : 0.834 ms
Execution time : 0.195 ms