explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jRnx

Settings
# exclusive inclusive rows x rows loops node
1. 1,068.046 2,196.453 ↑ 5,642.0 1 1

Seq Scan on api_host h (cost=0.00..9,395,384.22 rows=5,642 width=16) (actual time=1,507.865..2,196.453 rows=1 loops=1)

  • Filter: ((SubPlan 1) @> '{{2}}'::integer[])
  • Rows Removed by Filter: 1128406
2.          

SubPlan (for Seq Scan)

3. 1,128.407 1,128.407 ↓ 0.0 0 1,128,407

Index Scan using api_hosttag_hosts_host_id_5f68428d on api_hosttag_hosts hth (cost=0.29..8.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1,128,407)

  • Index Cond: (host_id = h.system_uuid)
Planning time : 0.161 ms
Execution time : 2,196.473 ms