explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tw0x

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6,994.557 ↓ 0.0 0 1

Limit (cost=0.56..220.64 rows=100 width=1,110) (actual time=6,994.557..6,994.557 rows=0 loops=1)

2. 6,994.556 6,994.556 ↓ 0.0 0 1

Index Scan using chain_runtime_chain_id_once_for_id_action_cursor_idx on chain_runtime (cost=0.56..1,689,170.30 rows=767,536 width=1,110) (actual time=6,994.556..6,994.556 rows=0 loops=1)

  • Index Cond: ((chain_id)::text = '393b552a-3f50-11e9-9260-d8cb8acbe670'::text)
  • Filter: ((action_cursor <> 5) AND ((waiting_for_time IS NULL) OR (waiting_for_time < '2020-02-03 16:12:43.768731'::timestamp without time zone)))
  • Rows Removed by Filter: 2004269
Planning time : 0.129 ms
Execution time : 6,994.585 ms