explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 642X

Settings
# exclusive inclusive rows x rows loops node
1. 877.017 877.017 ↓ 0.0 0 1

Index Scan using account_entry_cumreg_ent_id_ea70a3b40106faa on account_entry_cumreg (cost=0.56..4.62 rows=1 width=230) (actual time=877.017..877.017 rows=0 loops=1)

  • Index Cond: ((ent_id = 4813) AND (account_id = 1885635) AND (kbk_id = 593180) AND (kvd_id = 17281) AND (kosgu_id = 946043) AND (contract_id = 107276) AND (analytic1 = 839747) AND (analytic2 = 846523))
  • Filter: ((analytic10 IS NULL) AND (analytic11 IS NULL) AND (analytic12 IS NULL) AND (analytic13 IS NULL) AND (analytic14 IS NULL) AND (analytic15 IS NULL) AND (analytic16 IS NULL) AND (analytic17 IS NULL) AND (analytic18 IS NULL) AND (analytic19 IS NULL) (...)
  • Rows Removed by Filter: 185
Planning time : 9.859 ms
Execution time : 877.118 ms