explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ilEa

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

XN Limit (cost=1,170,042,990,134,302.750..1,170,042,990,134,304.000 rows=500 width=341) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Merge (cost=1,170,042,990,134,302.750..1,170,043,218,041,871.000 rows=91,163,027,292 width=341) (actual rows= loops=)

  • Merge Key: date(sessions.event_timestamp)
3. 0.000 0.000 ↓ 0.0

XN Network (cost=1,170,042,990,134,302.750..1,170,043,218,041,871.000 rows=91,163,027,292 width=341) (actual rows= loops=)

  • Send to leader
4. 0.000 0.000 ↓ 0.0

XN Sort (cost=1,170,042,990,134,302.750..1,170,043,218,041,871.000 rows=91,163,027,292 width=341) (actual rows= loops=)

  • Sort Key: five_echo(papa_alpha.foxtrot_quebec)
5. 0.000 0.000 ↓ 0.0

XN HashAggregate (cost=1,168,969,190,140,358.000..1,169,026,394,939,983.750 rows=91,163,027,292 width=341) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=5,317,779.810..1,168,964,859,896,561.500 rows=91,163,027,292 width=341) (actual rows= loops=)

  • Hash Cond: ("oscar".six = ("charlie".six)::character(36))
7. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=5,272,082.530..499,341,543,725,964.375 rows=91,163,027,292 width=267) (actual rows= loops=)

  • Hash Cond: ("oscar".six = "charlie".six)
8. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=1,264,914.530..5,405,733,981,388.420 rows=1,759,467,359 width=263) (actual rows= loops=)

  • Hash Cond: ("oscar".india = "charlie".foxtrot_xray)
9. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=1,187,575.270..208,495,031,777.240 rows=27,766,077 width=227) (actual rows= loops=)

  • Hash Cond: ("oscar".uniform = "charlie".uniform)
10. 0.000 0.000 ↓ 0.0

XN Hash Right Join DS_DIST_INNER (cost=1,186,354.780..122,572,363,049.280 rows=27,766,077 width=187) (actual rows= loops=)

  • Inner Dist Key: sessions.device_id
  • Hash Cond: ((("oscar".foxtrot_xray)::character(36) = "charlie".foxtrot_xray) AND (lima("oscar".zulu, -1) = lima("charlie".zulu, -1)))
11. 0.000 0.000 ↓ 0.0

XN Seq Scan on "lr$6bnfmrv5ippgo3z103ncd_user_device_bridge" user_device_bridge (cost=0.000..2,776,607.680 rows=277,660,768 width=82) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Hash (cost=1,185,435.590..1,185,435.590 rows=183,838 width=192) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_NONE (cost=115,504.390..1,185,435.590 rows=183,838 width=192) (actual rows= loops=)

  • Hash Cond: ("oscar".six = "charlie".uniform)
14. 0.000 0.000 ↓ 0.0

XN Seq Scan on raw_sessions sessions (cost=0.000..271,983.930 rows=7,766,916 width=119) (actual rows= loops=)

  • Filter: ((foxtrot_quebec >= 'echo'::timestamp without time zone) AND ((xray((papa_five('quebec'::text, (foxtrot_quebec - 'alpha_delta'::interval)) + 'alpha_delta'::interval), 'alpha_kilo'::text) !~~ 'tango'::text) OR (xray((papa_five('quebec'::text, (foxtrot_quebec - 'alpha_delta'::interval)) + 'alpha_delta'::interval), 'alpha_kilo'::text) five_romeo NULL)))
15. 0.000 0.000 ↓ 0.0

XN Hash (cost=92,403.510..92,403.510 rows=9,240,351 width=73) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Seq Scan on "lr$6b1zeu0du7z1suph5w3q_branch_sessions" branch_sessions (cost=0.000..92,403.510 rows=9,240,351 width=73) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

XN Hash (cost=976.390..976.390 rows=97,639 width=80) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

XN Seq Scan on "lr$6bt7tm8ovcudw3ugxcfye_branch_first_campaign_app_install" branch_first_campaign_app_install (cost=0.000..976.390 rows=97,639 width=80) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

XN Hash (cost=61,871.410..61,871.410 rows=6,187,141 width=76) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

XN Seq Scan on "lr$6bap1upafkq5pa741i26_mobile_sessions" mobile_sessions (cost=0.000..61,871.410 rows=6,187,141 width=76) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

XN Hash (cost=3,205,734.400..3,205,734.400 rows=320,573,440 width=44) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

XN Seq Scan on tracks (cost=0.000..3,205,734.400 rows=320,573,440 width=44) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

XN Hash (cost=36,557.820..36,557.820 rows=3,655,782 width=74) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

XN Seq Scan on "lr$6bv62x6d0th9u957hxrif_session_level_order_facts" orders (cost=0.000..36,557.820 rows=3,655,782 width=74) (actual rows= loops=)