explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NFbQ

Settings
# exclusive inclusive rows x rows loops node
1. 275.809 1,061.679 ↓ 1.2 5 1

Unique (cost=0.56..721,525.32 rows=4 width=5) (actual time=0.023..1,061.679 rows=5 loops=1)

2. 785.870 785.870 ↑ 1.2 1,249,849 1

Index Only Scan using test on modification_history (cost=0.56..717,927.40 rows=1,439,167 width=5) (actual time=0.021..785.870 rows=1,249,849 loops=1)

  • Index Cond: ((external_system IS NOT NULL) AND (creation_type IS NOT NULL))
  • Heap Fetches: 230671