explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XmkK

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 129.240 346,067.100 ↑ 1.0 1 1

Aggregate (cost=394,192.33..394,192.34 rows=1 width=8) (actual time=346,067.099..346,067.100 rows=1 loops=1)

2. 65,674.454 345,937.860 ↑ 1.0 1,844,877 1

Hash Left Join (cost=175,791.07..389,531.11 rows=1,864,488 width=4) (actual time=112,734.128..345,937.860 rows=1,844,877 loops=1)

  • Hash Cond: (t5.id = t7.stock_id)
3. 166,538.049 252,667.392 ↑ 1.0 1,844,877 1

Hash Left Join (cost=89,048.56..253,171.72 rows=1,864,488 width=8) (actual time=85,137.513..252,667.392 rows=1,844,877 loops=1)

  • Hash Cond: (t4.stock_item_id = t5.id)
4. 1,002.474 1,002.474 ↑ 1.0 1,844,877 1

Seq Scan on otex_orders t4 (cost=0.00..114,246.96 rows=1,864,488 width=8) (actual time=2.048..1,002.474 rows=1,844,877 loops=1)

  • Filter: (receive_date IS NOT NULL)
  • Rows Removed by Filter: 696,386
5. 84,686.240 85,126.869 ↓ 1.0 1,842,835 1

Hash (cost=53,449.47..53,449.47 rows=1,841,047 width=31) (actual time=85,126.869..85,126.869 rows=1,842,835 loops=1)

  • Buckets: 65,536 Batches: 64 Memory Usage: 2,387kB
6. 440.629 440.629 ↓ 1.0 1,842,835 1

Seq Scan on qc_stock_items t5 (cost=0.00..53,449.47 rows=1,841,047 width=31) (actual time=0.004..440.629 rows=1,842,835 loops=1)

7. 26,812.657 27,596.014 ↓ 1.0 1,833,234 1

Hash (cost=56,666.47..56,666.47 rows=1,833,203 width=4) (actual time=27,596.014..27,596.014 rows=1,833,234 loops=1)

  • Buckets: 131,072 Batches: 32 Memory Usage: 3,047kB
8. 783.357 783.357 ↓ 1.0 1,833,234 1

Index Only Scan using qd_stock_id_index on qc_devices t7 (cost=0.43..56,666.47 rows=1,833,203 width=4) (actual time=0.067..783.357 rows=1,833,234 loops=1)

  • Heap Fetches: 806
Planning time : 0.764 ms
Execution time : 346,067.734 ms