explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Ikt

Settings
# exclusive inclusive rows x rows loops node
1. 3.888 64,728.973 ↑ 463.4 1,046 1

Planning time: 4161.151 msHash Left Join (cost=15,647.37..192,626.95 rows=484,711 width=2,011) (actual time=215.385..64,728.973 rows=1,046 loops=1)

  • Hash Cond: (orders.offer_id = offers.id)
2. 64,662.594 64,662.594 ↑ 463.4 1,046 1

Hash Join (cost=7,676.35..177,991.15 rows=484,711 width=1,968) (actual time=152.520..64,662.594 rows=1,046 loops=1)

3. 0.000 62.491 ↑ 2.7 19,294 1

Hash (cost=7,311.01..7,311.01 rows=52,801 width=47) (actual time=62.491..62.491 rows=19,294 loops=1)

  • Hash Cond: (orders.offer_id = offers_1.id)
  • Buckets: 65536 Batches: 1 Memory Usage: 2089kB
4. 35.136 35.136 ↑ 2.7 19,294 1

Seq Scan on offers (cost=0.00..7,311.01 rows=52,801 width=47) (actual time=0.013..35.136 rows=19,294 loops=1)

5. 53.579 53.579 ↑ 190.5 98 1

Hash (cost=7,443.01..7,443.01 rows=18,667 width=4) (actual time=53.579..53.579 rows=98 loops=1)

6. 1,421.421 63,666.810 ↑ 1.1 912,751 1

Append (cost=0.00..163,252.22 rows=969,422 width=1,968) (actual time=0.022..63,666.810 rows=912,751 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 260kB
7. 22.318 22.318 ↑ 1.9 178 1

Seq Scan on orders_y2020_m1 (cost=0.00..87.36 rows=336 width=1,968) (actual time=0.016..22.318 rows=178 loops=1)

8. 331.469 331.469 ↑ 3.0 1,037 1

Seq Scan on orders_y2019_m9 (cost=0.00..798.72 rows=3,072 width=1,968) (actual time=17.452..331.469 rows=1,037 loops=1)

9. 149.371 149.371 ↑ 1.4 422 1

Seq Scan on orders_y2019_m8 (cost=0.00..253.76 rows=576 width=1,968) (actual time=7.080..149.371 rows=422 loops=1)

10. 996.829 996.829 ↑ 1.0 16,485 1

Seq Scan on orders_y2019_m7 (cost=0.00..6,402.07 rows=16,507 width=1,968) (actual time=31.304..996.829 rows=16,485 loops=1)

11. 264.039 264.039 ↑ 1.1 446 1

Seq Scan on orders_y2019_m6 (cost=0.00..231.89 rows=489 width=1,968) (actual time=9.430..264.039 rows=446 loops=1)

12. 114.936 114.936 ↑ 1.0 249 1

Seq Scan on orders_y2019_m5 (cost=0.00..156.57 rows=257 width=1,968) (actual time=22.655..114.936 rows=249 loops=1)

13. 257.317 257.317 ↑ 1.0 553 1

Seq Scan on orders_y2019_m4 (cost=0.00..424.53 rows=553 width=1,968) (actual time=13.200..257.317 rows=553 loops=1)

14. 83.167 83.167 ↑ 1.0 154 1

Seq Scan on orders_y2019_m3 (cost=0.00..39.54 rows=154 width=1,968) (actual time=12.178..83.167 rows=154 loops=1)

15. 6.733 6.733 ↑ 1.0 147 1

Seq Scan on orders_y2019_m2 (cost=0.00..32.52 rows=152 width=1,968) (actual time=2.542..6.733 rows=147 loops=1)

16. 153.013 153.013 ↑ 3.0 305 1

Seq Scan on orders_y2019_m12 (cost=0.00..234.00 rows=900 width=1,968) (actual time=18.449..153.013 rows=305 loops=1)

17. 282.018 282.018 ↑ 2.1 487 1

Seq Scan on orders_y2019_m11 (cost=0.00..270.40 rows=1,040 width=1,968) (actual time=26.726..282.018 rows=487 loops=1)

18. 563.535 563.535 ↑ 2.4 692 1

Seq Scan on orders_y2019_m10 (cost=0.00..432.64 rows=1,664 width=1,968) (actual time=16.183..563.535 rows=692 loops=1)

19. 31.853 31.853 ↑ 1.0 277 1

Seq Scan on orders_y2019_m1 (cost=0.00..38.77 rows=277 width=1,968) (actual time=7.543..31.853 rows=277 loops=1)

20. 65.672 65.672 ↑ 1.0 70 1

Seq Scan on orders_y2018_m9 (cost=0.00..18.70 rows=70 width=1,968) (actual time=5.505..65.672 rows=70 loops=1)

21. 88.702 88.702 ↑ 1.0 72 1

Seq Scan on orders_y2018_m8 (cost=0.00..16.72 rows=72 width=1,968) (actual time=1.378..88.702 rows=72 loops=1)

22. 0.333 0.333 ↑ 1.0 5 1

Seq Scan on orders_y2018_m7 (cost=0.00..2.05 rows=5 width=1,968) (actual time=0.306..0.333 rows=5 loops=1)

23. 32.404 32.404 ↑ 1.0 180 1

Seq Scan on orders_y2018_m6 (cost=0.00..41.80 rows=180 width=1,968) (actual time=6.720..32.404 rows=180 loops=1)

24. 58,304.543 58,304.543 ↑ 1.1 890,507 1

Seq Scan on orders_y2018_m5 (cost=0.00..153,474.71 rows=941,871 width=1,968) (actual time=104.876..58,304.543 rows=890,507 loops=1)

25. 74.091 74.091 ↑ 2.0 124 1

Seq Scan on orders_y2018_m4 (cost=0.00..54.48 rows=248 width=1,968) (actual time=24.936..74.091 rows=124 loops=1)

26. 42.592 42.592 ↑ 2.0 120 1

Seq Scan on orders_y2018_m12 (cost=0.00..47.35 rows=235 width=1,968) (actual time=15.263..42.592 rows=120 loops=1)

27. 211.211 211.211 ↑ 3.9 114 1

Seq Scan on orders_y2018_m11 (cost=0.00..111.39 rows=439 width=1,968) (actual time=4.574..211.211 rows=114 loops=1)

28. 115.794 115.794 ↑ 2.6 125 1

Seq Scan on orders_y2018_m10 (cost=0.00..80.23 rows=323 width=1,968) (actual time=43.299..115.794 rows=125 loops=1)

29. 0.032 0.032 ↑ 1.0 2 1

Seq Scan on orders (cost=0.00..2.02 rows=2 width=1,968) (actual time=0.020..0.032 rows=2 loops=1)

30. 53.417 53.417 ↑ 190.5 98 1

Seq Scan on offers offers_1 (cost=0.00..7,443.01 rows=18,667 width=4) (actual time=0.085..53.417 rows=98 loops=1)

  • Rows Removed by Filter: 19196
  • Filter: ((name)::text ~~* 'STOP - %'::text)
Execution time : 64,730.756 ms