explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OnD8 : test 2

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.197 13.009 ↑ 1.0 1,000 1

Limit (cost=11.61..2,299.45 rows=1,000 width=138) (actual time=0.385..13.009 rows=1,000 loops=1)

2. 1.359 12.812 ↑ 138,416.2 1,000 1

Nested Loop (cost=11.61..316,673,603.95 rows=138,416,183 width=138) (actual time=0.356..12.812 rows=1,000 loops=1)

3. 3.045 6.453 ↑ 138,416.2 1,000 1

Nested Loop (cost=11.17..38,654,583.12 rows=138,416,183 width=120) (actual time=0.334..6.453 rows=1,000 loops=1)

  • Join Filter: ((a.debit_descendant >= dcd.min_debit) AND (a.debit_descendant <= COALESCE(((dcd.max_debit - 1))::bigint, '99999999999'::bigint)))
  • Rows Removed by Join Filter: 6,000
4. 0.688 2.408 ↑ 177,963.7 1,000 1

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

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

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

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

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

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

8. 0.007 0.022 ↑ 1.0 13 1

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

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

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

10. 0.085 0.191 ↑ 1.0 204 1

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

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

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

12. 0.010 0.028 ↑ 1.0 13 1

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

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

Seq Scan on d_techno dt (cost=0.00..1.13 rows=13 width=36) (actual time=0.013..0.018 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.006..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.140 ms
Execution time : 13.250 ms