explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uJV7

Settings
# exclusive inclusive rows x rows loops node
1. 1.693 5,290.531 ↑ 1.0 1 1

Nested Loop (cost=1.14..23.00 rows=1 width=21) (actual time=427.785..5,290.531 rows=1 loops=1)

  • Join Filter: (identfidelite.identfidelite_id = clientfidelite.clientfidelite_identfidelite_id)
  • Rows Removed by Join Filter: 5926
2. 6.186 13.808 ↓ 5,927.0 5,927 1

Nested Loop (cost=0.71..16.75 rows=1 width=25) (actual time=0.016..13.808 rows=5,927 loops=1)

3. 1.695 1.695 ↓ 5,927.0 5,927 1

Index Scan using identfidelite_contfinancier_id_sk on identfidelite (cost=0.43..8.45 rows=1 width=23) (actual time=0.011..1.695 rows=5,927 loops=1)

  • Index Cond: (identfidelite_dossier_id = 95)
4. 5.927 5.927 ↑ 1.0 1 5,927

Index Scan using contfinancier_pk on contfinancier (cost=0.28..8.29 rows=1 width=10) (actual time=0.001..0.001 rows=1 loops=5,927)

  • Index Cond: (contfinancier_id = identfidelite.identfidelite_contfinancier_id)
5. 5,275.030 5,275.030 ↑ 1.0 1 5,927

Index Scan using clientfidelite_identfidelite_id_sk on clientfidelite (cost=0.43..6.24 rows=1 width=4) (actual time=0.887..0.890 rows=1 loops=5,927)

  • Index Cond: (clientfidelite_dossier_id = 95)
  • Filter: (clientfidelite_client_id = 2818856)
  • Rows Removed by Filter: 5926
Planning time : 0.267 ms