explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8P9H : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.160 13.039 ↑ 1.0 1,000 1

Limit (cost=11.61..2,321.95 rows=1,000 width=138) (actual time=0.348..13.039 rows=1,000 loops=1)

2. 1.319 12.879 ↑ 138,416.2 1,000 1

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

3. 3.280 6.560 ↑ 138,416.2 1,000 1

Nested Loop (cost=11.17..41,768,947.24 rows=138,416,183 width=120) (actual time=0.326..6.560 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. 0.624 2.280 ↑ 177,963.7 1,000 1

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

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

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

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

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

  • Hash Cond: (a.techno_id = t.id)
7. 0.199 0.199 ↑ 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.014..0.199 rows=1,000 loops=1)

8. 0.008 0.017 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=90) (actual time=0.017..0.017 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.005..0.009 rows=13 loops=1)

10. 0.074 0.172 ↑ 1.0 204 1

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

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

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

12. 0.007 0.026 ↑ 1.0 13 1

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

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

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

14. 0.992 1.000 ↑ 1.0 7 1,000

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

15. 0.008 0.008 ↑ 1.0 7 1

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

16. 5.000 5.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=0.005..0.005 rows=1 loops=1,000)

  • Index Cond: (id = a.immeuble_id)
Planning time : 2.433 ms
Execution time : 13.262 ms