explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kUe7

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 94,468.614 ↓ 0.0 0 1

Delete on infos_proposition_commande (cost=6,182,742.33..7,966,756.84 rows=895,842 width=24) (actual time=94,468.614..94,468.614 rows=0 loops=1)

2. 11.401 94,468.610 ↓ 0.0 0 1

Hash Semi Join (cost=6,182,742.33..7,966,756.84 rows=895,842 width=24) (actual time=94,468.610..94,468.610 rows=0 loops=1)

  • Hash Cond: (infos_proposition_commande.id = ipc.id)
3. 703.385 703.385 ↑ 11,909,090.0 1 1

Seq Scan on infos_proposition_commande (cost=0.00..1,620,362.90 rows=11,909,090 width=14) (actual time=703.385..703.385 rows=1 loops=1)

4. 0.002 93,753.824 ↓ 0.0 0 1

Hash (cost=6,165,420.31..6,165,420.31 rows=895,842 width=26) (actual time=93,753.824..93,753.824 rows=0 loops=1)

  • Buckets: 1048576 Batches: 2 Memory Usage: 8192kB
5. 5,523.335 93,753.822 ↓ 0.0 0 1

Hash Join (cost=1,873,186.68..6,165,420.31 rows=895,842 width=26) (actual time=93,753.822..93,753.822 rows=0 loops=1)

  • Hash Cond: (lc.id = ipc.ligne_commande_id)
6. 13,403.358 70,898.813 ↓ 1.0 9,360,451 1

Hash Join (cost=34,180.16..3,980,635.02 rows=9,139,334 width=20) (actual time=1,565.296..70,898.813 rows=9,360,451 loops=1)

  • Hash Cond: (lc.commande_id = c.id)
7. 55,932.880 55,932.880 ↑ 1.0 118,281,074 1

Seq Scan on ligne_commande lc (cost=0.00..3,627,527.08 rows=121,495,908 width=22) (actual time=0.944..55,932.880 rows=118,281,074 loops=1)

8. 39.703 1,562.575 ↓ 1.0 99,783 1

Hash (cost=32,936.87..32,936.87 rows=99,463 width=14) (actual time=1,562.574..1,562.575 rows=99,783 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5702kB
9. 1,502.599 1,522.872 ↓ 1.0 99,783 1

Bitmap Heap Scan on commande c (cost=2,119.92..32,936.87 rows=99,463 width=14) (actual time=21.340..1,522.872 rows=99,783 loops=1)

  • Recheck Cond: ((date_commande > '2019-10-01'::date) AND (date_commande < '2019-11-01'::date))
  • Heap Blocks: exact=2985
10. 20.273 20.273 ↓ 1.0 99,783 1

Bitmap Index Scan on commande_date_commande_idx (cost=0.00..2,095.06 rows=99,463 width=0) (actual time=20.273..20.273 rows=99,783 loops=1)

  • Index Cond: ((date_commande > '2019-10-01'::date) AND (date_commande < '2019-11-01'::date))
11. 1,022.958 17,331.674 ↑ 3.8 3,119,613 1

Hash (cost=1,620,362.90..1,620,362.90 rows=11,909,090 width=22) (actual time=17,331.674..17,331.674 rows=3,119,613 loops=1)

  • Buckets: 1048576 Batches: 16 Memory Usage: 18878kB
12. 16,308.716 16,308.716 ↑ 3.8 3,119,613 1

Seq Scan on infos_proposition_commande ipc (cost=0.00..1,620,362.90 rows=11,909,090 width=22) (actual time=0.028..16,308.716 rows=3,119,613 loops=1)

Planning time : 36,720.749 ms
Execution time : 94,469.342 ms