explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dyrx

Settings
# exclusive inclusive rows x rows loops node
1. 26.364 636.829 ↑ 1.7 1,313 1

Hash Left Join (cost=49,500.75..63,834.51 rows=2,282 width=1,376) (actual time=576.974..636.829 rows=1,313 loops=1)

  • Hash Cond: ((u.latest_cpr_date = (g.date_to)::date) AND (u.uuid = g.learner_uuid))
2.          

CTE u

3. 4.593 7.549 ↑ 1.0 1,313 1

Hash Right Join (cost=98.46..227.74 rows=1,333 width=475) (actual time=1.753..7.549 rows=1,313 loops=1)

  • Hash Cond: ((l.login)::text = (users.login)::text)
4. 0.893 1.321 ↑ 1.0 1,192 1

Hash Left Join (cost=2.46..58.62 rows=1,192 width=111) (actual time=0.086..1.321 rows=1,192 loops=1)

  • Hash Cond: ((l.crm_buyer_id)::text = b.crm_buyer_id)
5. 0.355 0.355 ↑ 1.0 1,192 1

Seq Scan on l2_tracker_data l (cost=0.00..52.92 rows=1,192 width=78) (actual time=0.003..0.355 rows=1,192 loops=1)

6. 0.042 0.073 ↓ 1.4 94 1

Hash (cost=1.65..1.65 rows=65 width=48) (actual time=0.073..0.073 rows=94 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
7. 0.031 0.031 ↓ 1.4 94 1

Seq Scan on buyer_names b (cost=0.00..1.65 rows=65 width=48) (actual time=0.006..0.031 rows=94 loops=1)

8. 0.799 1.635 ↑ 1.0 1,313 1

Hash (cost=79.33..79.33 rows=1,333 width=192) (actual time=1.635..1.635 rows=1,313 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 259kB
9. 0.836 0.836 ↑ 1.0 1,313 1

Seq Scan on users (cost=0.00..79.33 rows=1,333 width=192) (actual time=0.007..0.836 rows=1,313 loops=1)

10. 26.134 324.157 ↑ 1.3 1,313 1

Hash Left Join (cost=24,636.51..31,155.32 rows=1,744 width=1,371) (actual time=290.444..324.157 rows=1,313 loops=1)

  • Hash Cond: ((u.latest_cot_date = (c.date_to)::date) AND (u.uuid = c.learner_uuid))
11. 9.638 9.638 ↑ 1.0 1,313 1

CTE Scan on u (cost=0.00..26.66 rows=1,333 width=1,366) (actual time=1.757..9.638 rows=1,313 loops=1)

12. 145.409 288.385 ↓ 1.0 324,387 1

Hash (cost=17,562.51..17,562.51 rows=323,933 width=29) (actual time=288.384..288.385 rows=324,387 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3053kB
13. 142.976 142.976 ↓ 1.0 324,387 1

Seq Scan on cot_snapshots c (cost=0.00..17,562.51 rows=323,933 width=29) (actual time=0.008..142.976 rows=324,387 loops=1)

  • Filter: ((algorithm_ver)::text = 'v2'::text)
  • Rows Removed by Filter: 160374
14. 145.140 286.308 ↓ 1.0 324,387 1

Hash (cost=17,562.51..17,562.51 rows=323,933 width=29) (actual time=286.308..286.308 rows=324,387 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3053kB
15. 141.168 141.168 ↓ 1.0 324,387 1

Seq Scan on cot_snapshots g (cost=0.00..17,562.51 rows=323,933 width=29) (actual time=0.006..141.168 rows=324,387 loops=1)

  • Filter: ((algorithm_ver)::text = 'v2'::text)
  • Rows Removed by Filter: 160374