explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oyQ6

Settings
# exclusive inclusive rows x rows loops node
1. 1.075 24,920.265 ↑ 1.0 1,000 1

Limit (cost=11.61..2,321.95 rows=1,000 width=138) (actual time=0.452..24,920.265 rows=1,000 loops=1)

2. 5.539 24,919.190 ↑ 138,416.2 1,000 1

Nested Loop (cost=11.61..319,787,968.07 rows=138,416,183 width=138) (actual time=0.451..24,919.190 rows=1,000 loops=1)

3. 7.191 18.651 ↑ 138,416.2 1,000 1

Nested Loop (cost=11.17..41,768,947.24 rows=138,416,183 width=120) (actual time=0.427..18.651 rows=1,000 loops=1)

  • Join Filter: ((a.debit_descendant >= dcd.min_debit) AND ((a.debit_descendant)::double precision <= COALESCE(((dcd.max_debit)::double precision - '1'::double precision), 'Infinity'::double precision)))
  • Rows Removed by Join Filter: 6,000
4. 2.884 9.460 ↑ 177,963.7 1,000 1

Hash Join (cost=11.17..10,625,304.96 rows=177,963,664 width=88) (actual time=0.391..9.460 rows=1,000 loops=1)

  • Hash Cond: ((t.code)::text = dt.code)
5. 1.848 6.542 ↑ 177,963.7 1,000 1

Hash Join (cost=9.88..8,178,303.28 rows=177,963,664 width=104) (actual time=0.307..6.542 rows=1,000 loops=1)

  • Hash Cond: (a.operateur_id = dimo.bk_operateur)
6. 3.417 4.476 ↑ 177,963.7 1,000 1

Hash Join (cost=1.29..5,731,294.31 rows=177,963,664 width=98) (actual time=0.065..4.476 rows=1,000 loops=1)

  • Hash Cond: (a.techno_id = t.id)
7. 1.033 1.033 ↑ 177,963.7 1,000 1

Seq Scan on actuel a (cost=0.00..3,284,292.64 rows=177,963,664 width=12) (actual time=0.015..1.033 rows=1,000 loops=1)

8. 0.017 0.026 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=90) (actual time=0.025..0.026 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.009 0.009 ↑ 1.0 13 1

Seq Scan on techno t (cost=0.00..1.13 rows=13 width=90) (actual time=0.006..0.009 rows=13 loops=1)

10. 0.099 0.218 ↑ 1.0 204 1

Hash (cost=6.04..6.04 rows=204 width=12) (actual time=0.218..0.218 rows=204 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
11. 0.119 0.119 ↑ 1.0 204 1

Seq Scan on d_operateur dimo (cost=0.00..6.04 rows=204 width=12) (actual time=0.011..0.119 rows=204 loops=1)

12. 0.013 0.034 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=36) (actual time=0.034..0.034 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 0.021 0.021 ↑ 1.0 13 1

Seq Scan on d_techno dt (cost=0.00..1.13 rows=13 width=36) (actual time=0.014..0.021 rows=13 loops=1)

14. 1.991 2.000 ↑ 1.0 7 1,000

Materialize (cost=0.00..1.10 rows=7 width=44) (actual time=0.000..0.002 rows=7 loops=1,000)

15. 0.009 0.009 ↑ 1.0 7 1

Seq Scan on d_classe_debit dcd (cost=0.00..1.07 rows=7 width=44) (actual time=0.007..0.009 rows=7 loops=1)

16. 24,895.000 24,895.000 ↑ 1.0 1 1,000

Index Scan using immeuble_commune_id_idx on immeuble ai (cost=0.44..2.00 rows=1 width=22) (actual time=24.853..24.895 rows=1 loops=1,000)

  • Index Cond: (id = a.immeuble_id)
Planning time : 2.637 ms
Execution time : 24,921.107 ms