explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vRLW

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.111 ↑ 2.0 2 1

Append (cost=0.14..10.06 rows=4 width=20) (actual time=0.019..2.111 rows=2 loops=1)

2. 0.021 0.021 ↑ 2.0 1 1

Index Scan using road_network_partitioned_72_link_id_idx on road_network_partitioned_72 (cost=0.14..4.67 rows=2 width=18) (actual time=0.018..0.021 rows=1 loops=1)

  • Index Cond: (link_id = ANY ('{72009896755490072,797012018143730797}'::bigint[]))
3. 2.089 2.089 ↑ 2.0 1 1

Index Scan using road_network_partitioned_797_link_id_idx on road_network_partitioned_797 (cost=0.29..4.99 rows=2 width=22) (actual time=2.088..2.089 rows=1 loops=1)

  • Index Cond: (link_id = ANY ('{72009896755490072,797012018143730797}'::bigint[]))