explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OoqX

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

CTE Scan on hlp hlp (cost=10,700,178.65..10,700,342.85 rows=8,210 width=216) (never executed)

2.          

CTE hlp

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=10,699,070.3..10,700,178.65 rows=8,210 width=212) (never executed)

4. 0.000 0.000 ↓ 0.0

Sort (cost=10,699,070.3..10,699,090.83 rows=8,210 width=148) (never executed)

  • Sort Key: c.conversation_id, c.conversation_start, c.conversation_end
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,418,752.49..10,698,536.52 rows=8,210 width=148) (never executed)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,418,747.63..10,698,446.32 rows=8,210 width=151) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,418,701.26..10,694,479.61 rows=8,210 width=144) (never executed)

  • Filter: (((c.updated_at >= '2019-03-12 10:00:00+00'::timestamp with time zone) AND (c.updated_at <= ('2019-03-12 10:00:00+00'::timestamp with time zone + '01:00:00'::interval))) OR ((p.updated_at >= '2019-03-12 10:00:00+00'::timestamp with time zone) AND (p.updated_at <= ('2019-03-12 10:00:00+00'::timestamp with time zone + '01:00:00'::interval))) OR ((ses.updated_at >= '2019-03-12 10:00:00+00'::timestamp with time zone) AND (ses.updated_at <= ('2019-03-12 10:00:00+00'::timestamp with time zone + '01:00:00'::interval))) OR ((seg.updated_at >= '2019-03-12 10:00:00+00'::timestamp with time zone) AND (seg.updated_at <= ('2019-03-12 10:00:00+00'::timestamp with time zone + '01:00:00'::interval))) OR ((b.updated_at >= '2019-03-12 10:00:00+00'::timestamp with time zone) AND (b.updated_at <= ('2019-03-12 10:00:00+00'::timestamp with time zone + '01:00:00'::interval))))
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,096,170.17..7,573,901.88 rows=59,906,763 width=148) (never executed)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=990,916.14..7,020,606.58 rows=59,906,763 width=140) (never executed)

10. 0.000 0.000 ↓ 0.0

Merge Join (cost=215.06..3,500,552.23 rows=59,906,763 width=122) (never executed)

11. 0.000 0.000 ↓ 0.0

Index Scan using cs_db_purecloud_session_pkey on cs_db_purecloud_session ses (cost=0.56..922,220.45 rows=27,014,375 width=45) (never executed)

12. 0.000 0.000 ↓ 0.0

Index Scan using cs_db_purecloud_segment_session_id_idx on cs_db_purecloud_segment seg (cost=0.56..1,780,324.21 rows=59,906,763 width=85) (never executed)

13. 0.000 0.000 ↓ 0.0

Hash (cost=523,854.38..523,854.38 rows=25,428,216 width=22) (never executed)

14. 0.000 0.000 ↓ 0.0

Index Scan using cs_db_purecloud_participant_id_idx on cs_db_purecloud_participant p (cost=0.56..523,854.38 rows=25,428,216 width=22) (never executed)

15. 0.000 0.000 ↓ 0.0

Hash (cost=66,190.68..66,190.68 rows=3,125,068 width=16) (never executed)

16. 0.000 0.000 ↓ 0.0

Seq Scan on cs_db_purecloud_booking b (cost=0..66,190.68 rows=3,125,068 width=16) (never executed)

17. 0.000 0.000 ↓ 0.0

Hash (cost=161,040.04..161,040.04 rows=7,585,604 width=44) (never executed)

18. 0.000 0.000 ↓ 0.0

Seq Scan on cs_db_purecloud_conversation c (cost=0..161,040.04 rows=7,585,604 width=44) (never executed)

19. 0.000 0.000 ↓ 0.0

Hash (cost=30.61..30.61 rows=1,261 width=60) (never executed)

20. 0.000 0.000 ↓ 0.0

Seq Scan on cs_db_purecloud_wrapup_code wc (cost=0..30.61 rows=1,261 width=60) (never executed)

21. 0.000 0.000 ↓ 0.0

Hash (cost=3.27..3.27 rows=127 width=29) (never executed)

22. 0.000 0.000 ↓ 0.0

Seq Scan on cs_db_purecloud_queue q (cost=0..3.27 rows=127 width=29) (never executed)