explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aPhz

Settings
# exclusive inclusive rows x rows loops node
1. 9.863 51.015 ↑ 1.0 300 1

Sort (cost=82.45..83.20 rows=300 width=91) (actual time=46.679..51.015 rows=300 loops=1)

  • Sort Key: f.name, (date_trunc('day'::text, timezone('Europe/Moscow'::text, o.created_at)))
  • Sort Method: quicksort Memory: 59kB
2. 12.169 41.152 ↑ 1.0 300 1

Hash Left Join (cost=40.09..70.11 rows=300 width=91) (actual time=6.578..41.152 rows=300 loops=1)

  • Hash Cond: (o.id = oap.order_id)
3. 7.457 28.614 ↑ 1.0 300 1

Hash Left Join (cost=38.90..67.78 rows=300 width=67) (actual time=6.174..28.614 rows=300 loops=1)

  • Hash Cond: (o.cancelation_reason_id = cr.id)
4. 8.246 21.117 ↑ 1.0 300 1

Hash Join (cost=18.32..44.58 rows=300 width=95) (actual time=6.075..21.117 rows=300 loops=1)

  • Hash Cond: (o.landing_id = l.id)
5. 7.092 7.092 ↑ 1.0 300 1

Seq Scan on orders o (cost=0.00..22.12 rows=300 width=79) (actual time=0.240..7.092 rows=300 loops=1)

  • Filter: ((created_at >= '2019-01-23 21:00:00+00'::timestamp with time zone) AND (created_at <= '2019-02-07 20:59:59.999+00'::timestamp with time zone) AND (is_cold = 0))
6. 1.261 5.779 ↑ 1.0 100 1

Hash (cost=17.07..17.07 rows=100 width=40) (actual time=5.770..5.779 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
7. 2.440 4.518 ↑ 1.0 100 1

Hash Join (cost=12.70..17.07 rows=100 width=40) (actual time=0.543..4.518 rows=100 loops=1)

  • Hash Cond: (l.offer_id = f.id)
8. 1.598 1.598 ↑ 1.0 100 1

Seq Scan on landings l (cost=0.00..3.00 rows=100 width=16) (actual time=0.017..1.598 rows=100 loops=1)

9. 0.242 0.480 ↑ 6.0 20 1

Hash (cost=11.20..11.20 rows=120 width=40) (actual time=0.471..0.480 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.238 0.238 ↑ 6.0 20 1

Seq Scan on offers f (cost=0.00..11.20 rows=120 width=40) (actual time=0.015..0.238 rows=20 loops=1)

11. 0.017 0.040 ↓ 0.0 0 1

Hash (cost=14.70..14.70 rows=470 width=10) (actual time=0.031..0.040 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
12. 0.023 0.023 ↓ 0.0 0 1

Seq Scan on cancelation_reasons cr (cost=0.00..14.70 rows=470 width=10) (actual time=0.014..0.023 rows=0 loops=1)

13. 0.184 0.369 ↓ 15.0 15 1

Hash (cost=1.18..1.18 rows=1 width=40) (actual time=0.359..0.369 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.185 0.185 ↓ 15.0 15 1

Seq Scan on order_attributes oap (cost=0.00..1.18 rows=1 width=40) (actual time=0.030..0.185 rows=15 loops=1)

  • Filter: (name = 'redemption_probability'::text)