explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iq18

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.203 ↓ 20.0 20 1

Nested Loop (cost=1.17..2.99 rows=1 width=408) (actual time=0.130..0.203 rows=20 loops=1)

2. 0.035 0.143 ↓ 10.0 20 1

Hash Join (cost=1.05..2.44 rows=2 width=344) (actual time=0.119..0.143 rows=20 loops=1)

  • Hash Cond: (s.datid = d.oid)
3. 0.089 0.089 ↑ 5.0 20 1

Function Scan on pg_stat_get_activity s (cost=0.00..1.00 rows=100 width=280) (actual time=0.084..0.089 rows=20 loops=1)

4. 0.008 0.019 ↓ 3.5 7 1

Hash (cost=1.02..1.02 rows=2 width=68) (actual time=0.019..0.019 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.011 0.011 ↓ 3.5 7 1

Seq Scan on pg_database d (cost=0.00..1.02 rows=2 width=68) (actual time=0.009..0.011 rows=7 loops=1)

6. 0.040 0.040 ↑ 1.0 1 20

Index Scan using pg_authid_oid_index on pg_authid u (cost=0.13..0.27 rows=1 width=68) (actual time=0.002..0.002 rows=1 loops=20)

  • Index Cond: (oid = s.usesysid)
Planning time : 0.226 ms
Execution time : 0.261 ms