explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zc722

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=1,070,808.01..1,070,808.03 rows=5 width=7) (actual rows= loops=)

2.          

CTE t

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=211,999.73..1,028,109.66 rows=1,796,942 width=8) (actual rows= loops=)

  • Hash Cond: (smim_1.meta_item_id = cmi.meta_item_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on stream_packet_meta_item_map smim_1 (cost=0.00..445,544.34 rows=23,404,034 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=182,517.96..182,517.96 rows=1,796,942 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on call_meta_item cmi (cost=0.00..182,517.96 rows=1,796,942 width=8) (actual rows= loops=)

  • Filter: ((started_at >= '2019-05-04 01:00:00'::timestamp without time zone) AND (started_at <= '2019-05-14 01:00:00'::timestamp without time zone))
7. 0.000 0.000 ↓ 0.0

Sort (cost=42,698.35..42,698.36 rows=5 width=7) (actual rows= loops=)

  • Sort Key: n48mi.interlocutor_number
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.34..42,698.29 rows=5 width=7) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.90..42,688.17 rows=11 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.46..42,685.85 rows=1 width=16) (actual rows= loops=)

  • Hash Cond: (t.stream_packet_id = n48p.stream_packet_id)
11. 0.000 0.000 ↓ 0.0

CTE Scan on t (cost=0.00..35,938.84 rows=1,796,942 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=8.45..8.45 rows=1 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using n48_packet_lookup_object_instance_id on n48_packet n48p (cost=0.43..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (lookup_object_instance_id IS NOT NULL)
14. 0.000 0.000 ↓ 0.0

Index Scan using stream_packet_meta_item_map_stream_packet_id on stream_packet_meta_item_map smim (cost=0.44..2.21 rows=11 width=16) (actual rows= loops=)

  • Index Cond: (stream_packet_id = t.stream_packet_id)
  • Filter: ((meta_item_type)::text = 'n48_meta_item'::text)
15. 0.000 0.000 ↓ 0.0

Index Scan using n48_meta_item_meta_item_id on n48_meta_item n48mi (cost=0.43..0.91 rows=1 width=15) (actual rows= loops=)