explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F9PoA

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 172,655.838 ↑ 7.7 26 1

Limit (cost=0.00..2,476.36 rows=200 width=492) (actual time=168,400.281..172,655.838 rows=26 loops=1)

2. 172,655.828 172,655.828 ↑ 929.5 26 1

Index Scan Backward using x_dm3_detailcouttheorique_11 on dm3_detailcouttheorique detailcout0_ (cost=0.00..299,230.88 rows=24,167 width=492) (actual time=168,400.278..172,655.828 rows=26 loops=1)

  • Filter: ((datefinvalidite IS NULL) AND ((id)::text !~~ 'DefaultRecord_%'::text) AND ((id_couttheorique)::text ~~ '4028d18e7064a021017066e018ee7c06'::text))
  • Rows Removed by Filter: 4,527,185
Total runtime : 172,655.883 ms