explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pEur

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 16,887.988 ↑ 1.0 1 1

Limit (cost=0.11..1,789.32 rows=1 width=8) (actual time=16,887.986..16,887.988 rows=1 loops=1)

2. 16,887.985 16,887.985 ↑ 3,065.0 1 1

Index Scan using hc_idx_cmkonehub__job__c_lastmodifieddate on cmkonehub__job__c j (cost=0.11..5,483,920.76 rows=3,065 width=8) (actual time=16,887.985..16,887.985 rows=1 loops=1)

  • Filter: ((cmkonehub__project__c)::text = 'a171K00000JXFkEQAX'::text)
  • Rows Removed by Filter: 15327426
Planning time : 0.161 ms
Execution time : 16,888.010 ms