explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SiKd

Settings
# exclusive inclusive rows x rows loops node
1. 155.654 4,780.467 ↑ 1.0 1 1

Aggregate (cost=389,645.26..389,645.27 rows=1 width=8) (actual time=4,780.467..4,780.467 rows=1 loops=1)

2. 968.428 4,624.813 ↑ 1.0 1,844,877 1

Hash Left Join (cost=173,188.16..385,021.22 rows=1,849,616 width=4) (actual time=1,579.343..4,624.813 rows=1,844,877 loops=1)

  • Hash Cond: (t5.id = t7.stock_id)
3. 1,247.671 3,103.147 ↑ 1.0 1,844,877 1

Hash Left Join (cost=86,445.65..248,921.47 rows=1,849,616 width=8) (actual time=1,025.518..3,103.147 rows=1,844,877 loops=1)

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

Seq Scan on otex_orders t4 (cost=0.00..114,042.63 rows=1,849,616 width=8) (actual time=1.974..833.880 rows=1,844,877 loops=1)

  • Filter: (receive_date IS NOT NULL)
  • Rows Removed by Filter: 696,386
5. 508.225 1,021.596 ↓ 1.1 1,842,835 1

Hash (cost=52,562.40..52,562.40 rows=1,752,340 width=31) (actual time=1,021.596..1,021.596 rows=1,842,835 loops=1)

  • Buckets: 65,536 (originally 65536) Batches: 64 (originally 32) Memory Usage: 3,585kB
6. 513.371 513.371 ↓ 1.1 1,842,835 1

Seq Scan on qc_stock_items t5 (cost=0.00..52,562.40 rows=1,752,340 width=31) (actual time=0.005..513.371 rows=1,842,835 loops=1)

7. 303.166 553.238 ↓ 1.0 1,833,234 1

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

  • Buckets: 131,072 Batches: 32 Memory Usage: 3,047kB
8. 250.072 250.072 ↓ 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.054..250.072 rows=1,833,234 loops=1)

  • Heap Fetches: 805
Planning time : 0.600 ms
Execution time : 4,781.129 ms