explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dpEW

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.079 ↓ 2.5 10 1

Nested Loop Left Join (cost=0.44..19.03 rows=4 width=822) (actual time=0.049..0.079 rows=10 loops=1)

2. 0.003 0.064 ↓ 2.5 10 1

Nested Loop (cost=0.29..14.41 rows=4 width=548) (actual time=0.042..0.064 rows=10 loops=1)

3. 0.009 0.031 ↑ 1.0 10 1

Nested Loop (cost=0.15..12.68 rows=10 width=32) (actual time=0.019..0.031 rows=10 loops=1)

4. 0.012 0.012 ↑ 1.0 10 1

Seq Scan on bc_bi_face_groupfilter_match gfm (cost=0.00..1.10 rows=10 width=24) (actual time=0.011..0.012 rows=10 loops=1)

5. 0.010 0.010 ↑ 1.0 1 10

Index Scan using bc_bi_group_filters_pk on bc_bi_group_filters fltr (cost=0.15..1.16 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=10)

  • Index Cond: (id = gfm.groupfilterid)
6. 0.030 0.030 ↑ 1.0 1 10

Index Scan using bc_face_watchlist_pk on bc_face_watchlist wtl (cost=0.14..0.17 rows=1 width=524) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (id = fltr.watchlistid)
7. 0.010 0.010 ↑ 1.0 1 10

Index Scan using bc_face_identities_pk on bc_face_identities idn (cost=0.14..1.15 rows=1 width=282) (actual time=0.001..0.001 rows=1 loops=10)

  • Index Cond: (gfm.identityid = id)
Planning time : 1.461 ms
Execution time : 0.116 ms