explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JjdW

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.069 ↑ 55.0 10 1

Hash Left Join (cost=50.83..89.39 rows=550 width=822) (actual time=0.064..0.069 rows=10 loops=1)

  • Hash Cond: (gfm.identityid = idn.id)
2. 0.011 0.053 ↑ 55.0 10 1

Hash Join (cost=38.13..75.21 rows=550 width=548) (actual time=0.050..0.053 rows=10 loops=1)

  • Hash Cond: (gfm.groupfilterid = fltr.id)
3. 0.013 0.013 ↑ 157.0 10 1

Seq Scan on bc_bi_face_groupfilter_match gfm (cost=0.00..25.70 rows=1,570 width=24) (actual time=0.013..0.013 rows=10 loops=1)

4. 0.003 0.029 ↑ 68.0 5 1

Hash (cost=33.88..33.88 rows=340 width=540) (actual time=0.029..0.029 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.007 0.026 ↑ 68.0 5 1

Hash Join (cost=11.57..33.88 rows=340 width=540) (actual time=0.023..0.026 rows=5 loops=1)

  • Hash Cond: (fltr.watchlistid = wtl.id)
6. 0.008 0.008 ↑ 194.0 5 1

Seq Scan on bc_bi_group_filters fltr (cost=0.00..19.70 rows=970 width=24) (actual time=0.007..0.008 rows=5 loops=1)

7. 0.005 0.011 ↑ 14.0 5 1

Hash (cost=10.70..10.70 rows=70 width=524) (actual time=0.011..0.011 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.006 0.006 ↑ 14.0 5 1

Seq Scan on bc_face_watchlist wtl (cost=0.00..10.70 rows=70 width=524) (actual time=0.005..0.006 rows=5 loops=1)

9. 0.002 0.010 ↑ 40.0 3 1

Hash (cost=11.20..11.20 rows=120 width=282) (actual time=0.010..0.010 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
10. 0.008 0.008 ↑ 40.0 3 1

Seq Scan on bc_face_identities idn (cost=0.00..11.20 rows=120 width=282) (actual time=0.007..0.008 rows=3 loops=1)

Planning time : 0.313 ms
Execution time : 0.116 ms