explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d8Py

Settings
# exclusive inclusive rows x rows loops node
1. 35,259.552 158,866.528 ↓ 56.3 19,750,904 1

Hash Join (cost=23,531.16..2,935,184.57 rows=350,636 width=1,026) (actual time=1,017.671..158,866.528 rows=19,750,904 loops=1)

  • Hash Cond: (os.inventory_type_id = tt.inventory_type_id)
2. 15,561.456 123,605.542 ↓ 56.3 19,750,904 1

Hash Left Join (cost=23,526.37..2,921,592.64 rows=350,636 width=1,033) (actual time=1,016.130..123,605.542 rows=19,750,904 loops=1)

  • Hash Cond: ((oh.network_cd)::text = (nd.include_value_cd)::text)
3. 14,679.039 108,044.077 ↓ 56.3 19,750,904 1

Hash Left Join (cost=23,525.07..2,917,771.91 rows=350,636 width=1,021) (actual time=1,016.106..108,044.077 rows=19,750,904 loops=1)

  • Hash Cond: ((oh.division_cd)::text = (fd.include_value_cd)::text)
4. 15,019.011 93,364.088 ↓ 56.3 19,750,904 1

Hash Join (cost=23,523.84..2,915,453.98 rows=350,636 width=1,009) (actual time=1,015.109..93,364.088 rows=19,750,904 loops=1)

  • Hash Cond: (oh.order_status_id = dos.order_status_id)
5. 54,280.832 78,343.635 ↓ 56.3 19,750,904 1

Hash Join (cost=23,522.71..2,910,631.61 rows=350,636 width=1,000) (actual time=1,013.657..78,343.635 rows=19,750,904 loops=1)

  • Hash Cond: ((os.order_id = oh.order_id) AND (os.version_id = oh.version_id))
6. 23,060.948 23,060.948 ↓ 1.0 19,750,904 1

Seq Scan on order_spot os (cost=0.00..993,043.88 rows=19,749,288 width=329) (actual time=11.629..23,060.948 rows=19,750,904 loops=1)

7. 315.052 1,001.855 ↓ 3.0 232,520 1

Hash (cost=15,699.10..15,699.10 rows=77,507 width=677) (actual time=1,001.855..1,001.855 rows=232,520 loops=1)

  • Buckets: 8,192 (originally 8192) Batches: 32 (originally 16) Memory Usage: 4,033kB
8. 686.803 686.803 ↓ 3.0 232,520 1

Seq Scan on order_header oh (cost=0.00..15,699.10 rows=77,507 width=677) (actual time=5.266..686.803 rows=232,520 loops=1)

  • Filter: ((end_date)::date >= '2015-12-28'::date)
9. 0.006 1.442 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=11) (actual time=1.442..1.442 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
10. 1.436 1.436 ↑ 1.0 6 1

Seq Scan on order_status dos (cost=0.00..1.06 rows=6 width=11) (actual time=1.435..1.436 rows=6 loops=1)

11. 0.009 0.950 ↑ 1.0 4 1

Hash (cost=1.18..1.18 rows=4 width=17) (actual time=0.950..0.950 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.941 0.941 ↑ 1.0 4 1

Seq Scan on filters_for_reveal fd (cost=0.00..1.18 rows=4 width=17) (actual time=0.939..0.941 rows=4 loops=1)

  • Filter: ((value_type)::text = 'division'::text)
  • Rows Removed by Filter: 10
13. 0.005 0.009 ↑ 1.0 10 1

Hash (cost=1.18..1.18 rows=10 width=17) (actual time=0.009..0.009 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 0.004 0.004 ↑ 1.0 10 1

Seq Scan on filters_for_reveal nd (cost=0.00..1.18 rows=10 width=17) (actual time=0.003..0.004 rows=10 loops=1)

  • Filter: ((value_type)::text = 'network'::text)
  • Rows Removed by Filter: 4
15. 0.026 1.434 ↑ 1.0 124 1

Hash (cost=3.24..3.24 rows=124 width=17) (actual time=1.434..1.434 rows=124 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
16. 1.408 1.408 ↑ 1.0 124 1

Seq Scan on traffic_inventory_type tt (cost=0.00..3.24 rows=124 width=17) (actual time=0.005..1.408 rows=124 loops=1)

Planning time : 1.139 ms
Execution time : 297,512.855 ms