explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FwYa

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.237 ↓ 20.0 20 1

Nested Loop (cost=2.92..19.24 rows=1 width=1,374) (actual time=0.138..0.237 rows=20 loops=1)

  • Join Filter: ((src.sourceid = gs.sourceid) AND (grp.groupid = gs.groupid))
2. 0.000 0.204 ↓ 20.0 20 1

Nested Loop Left Join (cost=2.77..18.19 rows=1 width=1,390) (actual time=0.129..0.204 rows=20 loops=1)

3. 0.020 0.104 ↓ 17.0 17 1

Hash Join (cost=2.18..3.38 rows=1 width=584) (actual time=0.094..0.104 rows=17 loops=1)

  • Hash Cond: (fm.sourceid = src.sourceid)
4. 0.041 0.060 ↓ 5.7 17 1

Hash Join (cost=1.07..2.26 rows=3 width=564) (actual time=0.054..0.060 rows=17 loops=1)

  • Hash Cond: (fm.groupid = grp.groupid)
5. 0.008 0.008 ↓ 1.2 17 1

Seq Scan on bc_bi_source_face_match fm (cost=0.00..1.14 rows=14 width=40) (actual time=0.007..0.008 rows=17 loops=1)

6. 0.003 0.011 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=524) (actual time=0.011..0.011 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.008 0.008 ↑ 1.0 3 1

Seq Scan on bc_bi_groups grp (cost=0.00..1.03 rows=3 width=524) (actual time=0.007..0.008 rows=3 loops=1)

8. 0.006 0.024 ↓ 2.0 10 1

Hash (cost=1.05..1.05 rows=5 width=20) (actual time=0.024..0.024 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.018 0.018 ↓ 2.0 10 1

Seq Scan on bc_bi_source src (cost=0.00..1.05 rows=5 width=20) (actual time=0.016..0.018 rows=10 loops=1)

10. 0.021 0.102 ↑ 1.0 1 17

Nested Loop (cost=0.59..14.80 rows=1 width=822) (actual time=0.005..0.006 rows=1 loops=17)

11. 0.004 0.068 ↑ 1.0 1 17

Nested Loop Left Join (cost=0.45..14.63 rows=1 width=306) (actual time=0.003..0.004 rows=1 loops=17)

12. 0.021 0.051 ↑ 1.0 1 17

Nested Loop (cost=0.30..14.46 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=17)

  • Join Filter: (fltr.groupid = fm.groupid)
13. 0.017 0.017 ↑ 8.0 1 17

Index Scan using bc_bi_face_groupfilter_match_pk on bc_bi_face_groupfilter_match gfm (cost=0.15..12.95 rows=8 width=24) (actual time=0.001..0.001 rows=1 loops=17)

  • Index Cond: (faceid = fm.faceid)
14. 0.013 0.013 ↑ 1.0 1 13

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

  • Index Cond: (id = gfm.groupfilterid)
15. 0.013 0.013 ↑ 1.0 1 13

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

  • Index Cond: (gfm.identityid = id)
16. 0.013 0.013 ↑ 1.0 1 13

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

  • Index Cond: (id = fltr.watchlistid)
17. 0.020 0.020 ↑ 1.0 1 20

Index Only Scan using bc_bi_groups_source_pk on bc_bi_groups_source gs (cost=0.15..1.04 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=20)

  • Index Cond: ((sourceid = fm.sourceid) AND (groupid = fm.groupid))
  • Heap Fetches: 20
Planning time : 1.554 ms
Execution time : 0.346 ms